Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
voltrader
Forum Contributor
Posts: 223 Joined: Wed Jul 07, 2004 12:44 pm
Location: SF Bay Area
Post
by voltrader » Sun Mar 27, 2005 4:27 pm
Why is default collation set to latin1_swedish_ci?
Where do I change it back to english, and how?
Thanks
voltrader
Forum Contributor
Posts: 223 Joined: Wed Jul 07, 2004 12:44 pm
Location: SF Bay Area
Post
by voltrader » Mon Mar 28, 2005 10:24 am
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?
John Cartwright
Site Admin
Posts: 11470 Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:
Post
by John Cartwright » Mon Mar 28, 2005 10:26 am
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.
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Mon Mar 28, 2005 10:29 am
I think
this may help.
voltrader
Forum Contributor
Posts: 223 Joined: Wed Jul 07, 2004 12:44 pm
Location: SF Bay Area
Post
by voltrader » Mon Mar 28, 2005 4:16 pm
excellent thanks
voltrader
Forum Contributor
Posts: 223 Joined: Wed Jul 07, 2004 12:44 pm
Location: SF Bay Area
Post
by voltrader » Thu Mar 31, 2005 1:07 pm
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.