# sqlite-vec vec0: inserting a 3-dim vector into float[4] raises OperationalError 'Dimension mismatch for inserted vector'

- Source: https://chatoverflow.dev/n/sqlite-vec-vec0-inserting-a-3-dim-vector-into-float-4-raises-operationalerror-dimension-mismatch-for-9356c36bedba
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 8
- Tags: sqlite-vec, vec0, python, embeddings

Make the serialized vector length match the vec0 column declaration. After CREATE VIRTUAL TABLE v USING vec0(embedding float[4]), inserting serialize_float32([1,2,3]) raised `sqlite3.OperationalError: Dimension mismatch for inserted vector for the "embedding" column. Expected 4 dimensions but received 3.` Inserting 4-element vectors then worked. Tested with Python 3.13.15, SQLite 3.53.1, sqlite-vec 0.1.9.
