MySQL setting collation to latin1_swedish_ci

[bauhsoj]

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]

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]

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.