Issue Details (XML | Word | Printable)

Key: CORE-3447
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Philippe Makowski
Votes: 0
Watchers: 4
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Collation is not installed with icu > 4.2

Created: 19/Apr/11 06:01 AM   Updated: 27/May/15 03:41 PM
Component/s: Charsets/Collation
Affects Version/s: 2.5.0, 2.1.4
Fix Version/s: 2.5.1, 2.1.5, 3.0 Alpha 1

Environment: Firebird build with system icu under Linux

QA Status: Done successfully
Test Details: Passed on: WI-V2.5.5.26871, WI-T3.0.0.31844; LI-V2.5.3.26788, LI-T3.0.0.31842


 Description  « Hide
$ 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



 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Philippe Makowski made changes - 19/Apr/11 09:56 PM
Field Original Value New Value
Assignee Adriano dos Santos Fernandes [ asfernandes ]
Adriano dos Santos Fernandes made changes - 21/Apr/11 08:25 PM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 2.5.1 [ 10333 ]
Fix Version/s 3.0 Alpha 1 [ 10331 ]
Fix Version/s 2.1.5 [ 10420 ]
Resolution Fixed [ 1 ]
Philippe Makowski made changes - 16/May/12 12:54 PM
Status Resolved [ 5 ] Closed [ 6 ]
Pavel Zotov made changes - 27/May/15 03:41 PM
Status Closed [ 6 ] Closed [ 6 ]
Test Details Passed on: WI-V2.5.5.26871, WI-T3.0.0.31844; LI-V2.5.3.26788, LI-T3.0.0.31842
QA Status Done successfully