Page 1 of 1

Just upgraded from 3.23 to 4.1. Default collation?

Posted: Sun Mar 27, 2005 4:27 pm
by voltrader
Why is default collation set to latin1_swedish_ci?

Where do I change it back to english, and how?

Thanks

Posted: Sun Mar 27, 2005 4:40 pm
by John Cartwright
Currently am having the same problem. :evil:

Posted: Mon Mar 28, 2005 10:24 am
by voltrader
Do you think that this is going to pose future problems if we continue to use the database while the collation is set to latin1_swedish_ci?

Posted: Mon Mar 28, 2005 10:26 am
by John Cartwright
Whenever I try to dump my database for backups, and put it on my live server, it spits out errors.
I just run a quick search on the SQL to fix the DEFAULT.

Posted: Mon Mar 28, 2005 10:29 am
by feyd
I think this may help. :)

Posted: Mon Mar 28, 2005 10:33 am
by John Cartwright
Thanks feyder ;)

Posted: Mon Mar 28, 2005 4:16 pm
by voltrader
excellent thanks

Posted: Thu Mar 31, 2005 1:07 pm
by voltrader
I found the statement that should work:

SET character_set_results = NULL

Where do I put this? Under [mysqld] in my.cnf?

It's demonstrated as a command in the mysql shell.