Hi All,
After the original "Problem with CONTAINING and COLLATE" thread I
switched to UTF8 but not happy with it. The optional COLLATE after
CONTAINING have no effect, the database default COLLATION used. See the
below examples. Tried with 3.0.3.32854 snapshot and Linux 64bit (Ubuntu
14.04.1).
1.Database defaults: UTF8+UNICODE_CI
CREATE DATABASE 'CHARSET_TEST' PAGE_SIZE 4096 DEFAULT CHARACTER SET UTF8
COLLATION UNICODE_CI;
isql CHARSET_TEST -ch UTF8 -u SYSDBA
CREATE TABLE TABLE1 (NAME VARCHAR(60));
INSERT INTO TABLE1 (NAME) VALUES ('od');
INSERT INTO TABLE1 (NAME) VALUES ('őb');
INSERT INTO TABLE1 (NAME) VALUES ('Őc');
INSERT INTO TABLE1 (NAME) VALUES ('Oa');
SQL> SELECT * FROM TABLE1 WHERE NAME CONTAINING 'o';
NAME
============================================================
od
Oa
SQL> SELECT * FROM TABLE1 WHERE NAME CONTAINING 'ő';
NAME
============================================================
őb
Őc
SQL> SELECT * FROM TABLE1 WHERE NAME CONTAINING 'o' COLLATE UNICODE_CI_AI;
NAME
============================================================
od
Oa
SQL> SELECT * FROM TABLE1 WHERE NAME CONTAINING 'ő' COLLATE
UNICODE_CI_AI;
NAME
============================================================
őb
Őc
2.Database defaults: UTF8+UNICODE_CI_AI
CREATE DATABASE 'CHARSET_TEST' PAGE_SIZE 4096 DEFAULT CHARACTER SET UTF8
COLLATION UNICODE_CI_AI;
isql CHARSET_TEST -ch UTF8 -u SYSDBA
CREATE TABLE TABLE1 (NAME VARCHAR(60));
INSERT INTO TABLE1 (NAME) VALUES ('od');
INSERT INTO TABLE1 (NAME) VALUES ('őb');
INSERT INTO TABLE1 (NAME) VALUES ('Őc');
INSERT INTO TABLE1 (NAME) VALUES ('Oa');
SQL> SELECT * FROM TABLE1 WHERE NAME CONTAINING 'o';
NAME
============================================================
od
őb
Őc
Oa
SQL> SELECT * FROM TABLE1 WHERE NAME CONTAINING 'ő';
NAME
============================================================
od
őb
Őc
Oa
SQL> SELECT * FROM TABLE1 WHERE NAME CONTAINING 'o' COLLATE UNICODE_CI;
NAME
============================================================
od
őb
Őc
Oa
SQL> SELECT * FROM TABLE1 WHERE NAME CONTAINING 'ő' COLLATE UNICODE_CI;
NAME
============================================================
od
őb
Őc
Oa
Gabor
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
