MySQL 4.1 & Table Collation

I have changed my servers from the MySQL 4.0 branch to the 4.1 branch

now, in PhpMyAdmin when i login, it has a new field on all my MySQL tables called "collation"

the problem is, well, i think its a problem, is that all my tables have this collation:

latin1_swedish_ci

will this cause a problem?

i changed the collation in one of my databases to:

latin1_general_ci

which is what i think it should be.

All i want to know is if latin1_swedish_ci will cause any problems to existing databases if its left like that

and secondly if i should change the databases and tables to latin1_general_ci

also also, in the future, how do i make all tables and databases use latin1_general_ci by default

thanx

 

 

 

 

Top