MySQL Forums
Forum List  »  Newbie

how to set the collation to latin1_german2_ci
Posted by: Sven Buente
Date: May 20, 2005 12:18AM

Hi!

I'm trying to configure MySQL 4.1.12 (win) to run with the latin1_german2_ci collation.

All my search results in the help, on the web and in forums lead me to the explanation to start the server with "--collation-server=latin1_german2_ci"...
I am starting my server as a windows service, so I added these lines to the my.ini at the [mysqld] section:

character-set-server=latin1
collation-server=latin1_german2_ci

After restarting the server I opened the query browser and tried these:

show collation like 'latin1%'
The result shows the collations with latin1_swedish_ci marked as default?

show variables like 'collation%'
it results in:
collation_connection = utf8_general_ci
collation_database = latin1_swedish_ci
collation_server = latin1_swedish_ci

What must I do, to make latin1_german2_ci as my default collation?
Thanks a lot...

Options: ReplyQuote


Subject
Written By
Posted
how to set the collation to latin1_german2_ci
May 20, 2005 12:18AM


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.