MySQL setting collation to latin1_swedish_ci

bauhsoj · 01-31-2005, 10:13 PM

No matter how I configure MySQL 4.1.9, I always end up with all of my tables having collation set to "latin1_swedish_ci".

I have tried setting the collation to "latin1_general_ci" but my settings are ignored and all tables show up as "latin1_swedish_ci".

The tables that were created have been created and all data inserted through a PHPMyAdmin SQL file export under a server running MySQL 4.0.22.

Is there any way to fix this and what is might be causing it.

Thanks!

hemebond · 01-31-2005, 10:40 PM

Are you sure your SQL file doesn't contain these directives? If not, check your default settings in admin. There's an option to set the default charset.

bauhsoj · 01-31-2005, 10:53 PM

The default connection collation is set to "latin1_general_ci" and the default character set is "latin1_general_ci". Nothing in the SQL backup file specifies the character set and I have searched the entire file for "latin1_swedish_ci" but the string wasn't found.

01-31-2005, 10:13 PM	PM User \| #1
bauhsoj Regular Coder Join Date: Jan 2005 Posts: 462 Thanks: 3 Thanked 0 Times in 0 Posts	MySQL setting collation to latin1_swedish_ci No matter how I configure MySQL 4.1.9, I always end up with all of my tables having collation set to "latin1_swedish_ci". I have tried setting the collation to "latin1_general_ci" but my settings are ignored and all tables show up as "latin1_swedish_ci". The tables that were created have been created and all data inserted through a PHPMyAdmin SQL file export under a server running MySQL 4.0.22. Is there any way to fix this and what is might be causing it. Thanks!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

01-31-2005, 10:40 PM	PM User \| #2
hemebond Senior Coder Join Date: Jul 2004 Location: New Zealand Posts: 1,315 Thanks: 0 Thanked 2 Times in 2 Posts	Are you sure your SQL file doesn't contain these directives? If not, check your default settings in admin. There's an option to set the default charset.

01-31-2005, 10:53 PM	PM User \| #3
bauhsoj Regular Coder Join Date: Jan 2005 Posts: 462 Thanks: 3 Thanked 0 Times in 0 Posts	The default connection collation is set to "latin1_general_ci" and the default character set is "latin1_general_ci". Nothing in the SQL backup file specifies the character set and I have searched the entire file for "latin1_swedish_ci" but the string wasn't found.