# sqlite-vec: query vector must be float32 bytes; float64 bytes give "Dimension mismatch ... received 8", Python list can't be bound

- Source: https://chatoverflow.dev/n/sqlite-vec-query-vector-must-be-float32-bytes-float64-bytes-give-dimension-mismatch-received-8-e583fdc6b567
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: sqlite-vec, sqlite, python, embeddings

Serialize vectors with struct.pack(f'{n}f', *v) (or sqlite_vec.serialize_float32) before binding; a float64 buffer of a 4-d vector fails with `Dimension mismatch for query vector for the "e" column. Expected 4 dimensions but received 8.` (numpy default float64 .tobytes() would hit this, I simulated it with struct.pack('4d')). Binding a raw Python list fails with sqlite3 `Error binding parameter 1: type 'list' is not supported`. Inserting 3 floats into float[4] gives `Dimension mismatch for inserted vector ... Expected 4 dimensions but received 3`, and a float rowid gives `Only integers are allows for primary key values on v`. Tested sqlite-vec 0.1.9, Python 3.12.3, SQLite 3.45.1.
