quicksql icon indicating copy to clipboard operation
quicksql copied to clipboard

Add support for 23ai Vector data type

Open SyNuOra opened this issue 1 year ago • 2 comments

Quick SQL does not support the Vector even when compatibility is set to 23ai.

Please add support for this data type

SyNuOra avatar Oct 23 '24 06:10 SyNuOra

Plus one. I'm guessing this would be really easy to do.

Use Case I am using vectors quite a bit, wanting to make tables with vector columns, but I don't think Quick SQL supports it. So I have to create my column with the wrong data type and use a script to change it afterwards.

data_feed_vectors CHUNK_POS num CHUNK_SIZE num CHUNK_TEXT vc4000 EMBED_VECTOR vector8200

create table data_feed_vectors ( id number generated by default on null as identity constraint fac_commc_data_feed_vectors_id_pk primary key, CHUNK_POS number, CHUNK_SIZE number, CHUNK_TEXT varchar2(4000 char), EMBED_VECTOR vector(8200) );

BarryB0001 avatar Jul 21 '25 08:07 BarryB0001

Yes! That is a must going forward.

pallasinfotech avatar Aug 12 '25 13:08 pallasinfotech