Collation is not installed with icu > 4.2
-----------------------------------------
Key: CORE-3447
URL: http://tracker.firebirdsql.org/browse/CORE-3447
Project: Firebird Core
Issue Type: Bug
Components: Charsets/Collation
Affects Versions: 2.1.4, 2.5.0
Environment: Firebird build with system icu under Linux
Reporter: Philippe Makowski
$ ldd /usr/lib64/firebird/bin/fbserver | grep icu
libicuuc.so.44 => /usr/lib64/libicuuc.so.44 (0x00000038e9400000)
libicudata.so.44 => /usr/lib64/libicudata.so.44 (0x00000038e9c00000)
libicui18n.so.44 => /usr/lib64/libicui18n.so.44 (0x00000038eae00000)
show system collations;
give
UNICODE, CHARACTER SET UTF8, PAD SPACE, SYSTEM
UNICODE_CI, CHARACTER SET UTF8, FROM EXTERNAL ('UNICODE'), PAD SPACE,
CASE INSENSITIVE, SYSTEM
UNICODE_FSS, CHARACTER SET UNICODE_FSS, PAD SPACE, SYSTEM
UTF8, CHARACTER SET UTF8, PAD SPACE, SYSTEM
but :
SQL> create table test (C1 varchar(32) character set UTF8 collate UTF8,
C2 varchar(10) character set ISO8859_1 collate FR_FR);
SQL> show table test;
C1 VARCHAR(32) CHARACTER SET UTF8 Nullable
C2 VARCHAR(10) CHARACTER SET ISO8859_1 Nullable
COLLATE FR_FR
SQL> create table test2 (C1 varchar(32) character set UTF8 collate UNICODE);
Statement failed, SQLCODE = -607
unsuccessful metadata update
-TEST2
-COLLATION UNICODE for CHARACTER SET UTF8 is not installed
same with for unicode_ci and unicode_ci_ai and certainly others
reported first in Fedora bug tracker
https://bugzilla.redhat.com/show_bug.cgi?id=697313
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Benefiting from Server Virtualization: Beyond Initial Workload
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve
application availability and disaster protection. Learn more about boosting
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
