Why latin1_swedish_ci ????

[NickFritz]

Why is my new server Collation latin1_swedish_ci

Is there a way to change this?

Basically I imported stuff from an old server and its specified everything as

latin1_swedish_ci

i don't want any collation.

I tried manually removing the collation but it won't let me in phpmyadmin

It's stuffing up my vbulletin. :/

There must be a setting somewhere defaulting to latin1_swedish_ci

 

[alex2k]

Try dump your database using command line, like this:

mysqldump -u yourusername -p --skip-opt database_name > file_name.sql

Then upload to your new server using this command:

mysql -u yourusername -p database_name < file_name.sql

GOOD LUCK!!

 

[ballyn]

AFAIK, latin1_swedish_ci is the default character set, at least as of 4.1.

http://dev.mysql.com/doc/mysql/en/charset-server.html

The default can be changed at runtime, or you can recompile, or you can alter the database to use a different charset/collation.

http://dev.mysql.com/doc/mysql/en/charset-database.html

 

[NickFritz]

what should the charset be?

 

[jmstacey]

NickFritz,
That depends. I recommend just leaving it to the default values until you know why you would need to change them.

 

[NickFritz]

Thanks.