2

I've created a new collation as per the instructions mysql. In fact this tutorial was the exact use-case I needed. I've added the collation, and restarted mysql. When I try to run

ALTER TABLE `my_table` CHANGE COLUMN `my_column` `my_column` VARCHAR(32) CHARACTER SET 'latin1' COLLATE 'latin1_fulltext_ci' NOT NULL DEFAULT '' ;`

I get the error Error Code: 1273. Unknown collation: 'latin1_fulltext_ci'. When I run SELECT * FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME = 'latin1_fulltext_ci'; I get:

+--------------------+--------------------+----+------------+-------------+---------+
| COLLATION_NAME     | CHARACTER_SET_NAME | ID | IS_DEFAULT | IS_COMPILED | SORTLEN |
+--------------------+--------------------+----+------------+-------------+---------+
| latin1_fulltext_ci | latin1             | 62 |            |             |       0 |
+--------------------+--------------------+----+------------+-------------+---------+

So, I know MySQL is finding it. I've run repair, and check for upgrade on the tables and tried creating new tables, but I keep getting the same error Error Code: 1273. Unknown collation: 'latin1_fulltext_ci'.

Does anyone know what could be causing this?

Version details

mysql> SHOW VARIABLES LIKE "%version%";
+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| protocol_version        | 10                  |
| version                 | 5.1.73-log          |
| version_comment         | Source distribution |
| version_compile_machine | x86_64              |
| version_compile_os      | redhat-linux-gnu    |
+-------------------------+---------------------+
5 rows in set (0.00 sec)

closed as off-topic by RolandoMySQLDBA, Mark Storey-Smith, Max Vernon, Michael Green, ypercubeᵀᴹ Jan 19 '15 at 2:46

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – RolandoMySQLDBA, Mark Storey-Smith, Max Vernon, Michael Green, ypercubeᵀᴹ
If this question can be reworded to fit the rules in the help center, please edit the question.

0

I had an extra space in my collation in the latin1.xml file. Removing that, fixed it!

Not the answer you're looking for? Browse other questions tagged or ask your own question.