[Bug]: VECTOR data type values display as hex bytes instead of numeric arrays in query results #21806
Description
Description
The results grid and Edit Data data grids display VECTOR column values as raw binary hex strings
(e.g. 0xA9010300…) instead of human-readable float arrays. This issue was reported via Teams
and affects both the Query Results pane and the Edit Data view consistently.
Expected: [0.1, 2, 30]
Actual: 0xA901030000000000CDCCCC3D…
This issue was reported by @Strallee via Teams
Steps to Reproduce
- Connect to an Azure SQL database.
- Create a table with a
VECTOR(3)column:
CREATE TABLE dbo.vectors (id INT PRIMARY KEY, v VECTOR(3) NOT NULL);- Insert rows using string literals or
JSON_ARRAY():
INSERT INTO dbo.vectors VALUES
(1, '[0.1, 2, 30]'),
(2, '[-100.2, 0.123, 9.876]'),
(3, JSON_ARRAY(1.0, 2.0, 3.0));- Run
SELECT * FROM dbo.vectors;and observe thevcolumn in the Query Results pane. - Right-click the table → Edit Data — same hex output appears.
Affected Area
- Connection dialog (SQL Server | Azure browse/Fabric browse)
- Query editor
- Query results panel
- Object Explorer
- GitHub Copilot integration
- Preview/Edit data
- Table Designer
- Schema Designer
- Schema Compare
- Local SQL Server Container provisioning
- SQL database in Fabric provisioning
- DACPAC/BACPAC export/import
- SQL Database projects
- Query Plan Visualizer
- Other (please describe below)
If you selected "Other", please describe the affected area
No response
Environment Information
- VS Code:Latest
- MSSQL extension: Latest
Confirmation
- I have searched existing issues and couldn't find a match
- I want to work on this issue