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.

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.