Bug #55971 Adding new collation ended with error "Unknown collation"
Submitted: 13 Aug 2010 14:11 Modified: 15 Aug 2010 8:01
Reporter: Stanislav LOFAJ Email Updates:
Status: Verified Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:6.0.11-alpha, 5.5.5, 5.1.49 OS:Any (MS Windows, Linux)
Assigned to: Assigned Account CPU Architecture:Any
Tags: collation, server

[13 Aug 2010 14:11] Stanislav LOFAJ
When I add new collation utf8_test_ci into server file share\charsets\Index.xml 
an restart mysql server I can find new collation but create table 
with this collation is ending with error "Unknown collation: 'utf8_test_ci'"

How to repeat:
Test Code:
1. Insert new collation into utf8 section into file share\charsets\Index.xml 
  <collation name="utf8_test_ci"		id="222">
  mysql> SHOW COLLATION like "%test%";
  | Collation    | Charset | Id  | Default | Compiled | Sortlen |
  | utf8_test_ci | utf8    | 250 |         |          |       8 |
  1 row in set (0.00 sec)

3. Create table
  CREATE TABLE sk_test
  hodnota VARCHAR( 255 ) CHARACTER SET utf8  COLLATE utf8_test_ci  not null, 
  ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_test_ci ;

Problem is Many-characters-to-one-weight, becouse when i deleted this sequence
table was created
[13 Aug 2010 18:20] Sveta Smirnova
Thank you for the report.

Please send us full error log file and output of SHOW COLLATION;
[15 Aug 2010 8:01] Sveta Smirnova
Thank you for the feedback.

Verified as described.

Problem is there is no message in the error log and server shows this invalid collation as supported.