So I’m trying this out and I can’t seem to get it to work:
I’m creating my table like this:
create table ci_table (
value TEXT COLLATE en_u_ks_level2
As I only one one column case-insensitive
But I can’t insert into it. I get the following error from the Go PG driver:
ERROR: pq: error in argument for $2: unsupported OID 705 with format code formatText
And the following error when trying to insert from Data Grip:
ERROR: value type string doesn't match type COLLATEDSTRING of column "value"
The data_type returned from
where table_name = 'ci_table'
STRING COLLATE en_u_ks_level2
Does anyone have an example of Case Insensitive columns working with cockroach db?