Hello! The SQLite in the field with ICU collation does store the BOM in the start of string. This bahaviour produce some difficulty resolving problems.
select length(name),x.name, hex(x.name) from (select distinct name from const_telephony_direction where delete_date IS NULL) as x; ... 17|sovintel-konmark|EFBBBF736F76696E74656C2D6B6F6E6D61726B ... The hex sequence EFBBBF is UTF-8 byte order mark. The right value is 16|sovintel-konmark|736F76696E74656C2D6B6F6E6D61726B .schema const_telephony_direction CREATE TABLE const_telephony_direction ( ... name text collate russian not null, -- группа направлений ... ); pragma collation_list; 0|russian 1|NOCASE 2|RTRIM 3|BINARY Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users