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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
