Unknown collation: latin1_general_ci
Posted by: Luca Accomazzi
Date: September 05, 2006 04:25AM

I have added these few lines to my.cnf under [mysqld] on all of my boxes, to make them behave uniformly:
default-character-set = latin1
character-set-server = latin1
collation-server = latin1_general_ci

My Linuxes behave well, buy my Mac OS X laptop dies horribly:
060905 12:04:58 mysqld started
060905 12:04:58 [ERROR] Unknown collation: 'latin1_general_ci'
060905 12:04:58 [ERROR] Aborting

This seems quite weird to me, because if I restart the deamon with an empty my.cnf file I can then do this:
mysql> SET NAMES 'latin1' COLLATE 'latin1_general_ci';
Query OK, 0 rows affected (0.03 sec)

I'm running 4.1.18-standard and any help is very appreciated.

L.A.

Options: ReplyQuote


Subject
Views
Written By
Posted
Unknown collation: latin1_general_ci
5694
September 05, 2006 04:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.