MySQL 4.1 collations

[Earendil]

By default the server collation is set to latin1_swedish_ci
How can I change this to latin1_general_ci ?

[I-Web]

By default the server collation is set to latin1_swedish_ci
How can I change this to latin1_general_ci ?

Did you ever find an answer to this?

[I-Web]

Also is there anyway to change the setting globally.... MySQL has set them all by default to swedish and i want them set to general

[Earendil]

You can set it in your my.cnf

[I-Web]

Whats the line i need to add for this??

And how do i convert all my existing databases/tables to the collation i want......

[deieno]

Anyone has an answer, I have the same problem after update mysql.

[Daniel Artes]

SAME PROBLEAM OVER HERE...

wehen I export the data base into another data base everyhtings goes wrng coz of the collation thingy... -_-

[casey]

Probably nobody here is in this situation, but if somebody has a clue, please let me know.
I have gone through the trouble of converting EUC-JP encoded databases to UTF-8. The conversion went fine.

My problem is that even though I have converted the database to UTF-8 the characters do not show correctly (at all--just jibberish) in phpMyAdmin. They come up fine on the website, but I cannot edit anything using phpMyAdmin. Not a big deal, because I hardly ever use phpMyAdmin, but it is a convenience I'd rather not do without.

What do I need to do to the tables or whatever to make the characters show up properly?

[haze]

Curious.. what OS is this ?

[casey]

It's CentOS.

[deddy]

latin1_swedish_ci is a BUG within MySQL 4.1.10a
Normally it should be fixed in 4.1.9 but it is not.
Not nice indeed.

[Fredi]

Same is most problem!

Anione can give the answer for correcting?

[deddy]

vi /etc/my.cnf

and insert

default-character-set=latin1
default-collation=latin1_general_ci

This will fix the problem with latin1_swedish_ci

but unfortunatly not the problem regarding
foreign chars

[Fredi]

Thank You deddy,

However this does not solve whole problem!

I have a client using russian language.
For these client to use phpMyadmin - impossible!

The Coding windows-1251 and KOI-8 - are not supported!

Attempt to change all in

default-character-set=cp1251
default-collation=cp1251_general_ci

I get absolutely incorrect encoding.



We can expect correction from CP?

[casey]

#mysqldump -uUSER -pPASSWORD --default-character-set=binary USER_db > db.sql

Will get you a dump file in the proper encoding.

I used this file to replace the collations.

#replace "latin1" "utf8" -- db.sql

Voila! Now the database works in phpMyAdmin perfectly. The catch? Now it doesn't work on the site. All I get on the site now is ??????? (a bunch of question marks).

This is not a cpanel issue, but a mysql issue, so I doubt whether cpanel is going to try to come up with any automatic solutions. If we work together, though, we should be able to figure it out.