执行sql时where过滤带有like 提示
SQL 错误 [0A000]: 错误: LIKE不支持非确定性排序
SQL 错误 [0A000]: ERROR: nondeterministic collations are not supported for LIKE
原因是某些系统,使用不敏感的库,创建的表的字段后面带了排序规则,
例如
CREATE TABLE "public"."t2" (
"iD" integer NULL,
"name" character varying(100 char) NULL COLLATE "ci_x_icu",
"bz" character(200 char) NULL COLLATE "ci_x_icu"
);
解决办法:去掉表字段的排序规则,按正常的建表语句重新建立表,再把数据恢复到这表,即可
CREATE TABLE "public"."t2" (
"iD" integer NULL,
"name" character varying(100 char) NULL ,
"bz" character(200 char) NULL
);