Re: Change Collation

[PeterSwiss]

I had the same problem, just my database is only one day old and not very big.

(1) I changed the FIRST table manually to latin1_mylanguage_ci, using phpmyadmin. That's in TOOLS (WERKZEUGE in my language) of phpmyadmin.

(2) After I exported the whole data database to a .sql.zip file.

(3) I extract .sql and open it in Wordpad MFC.

(4) I notice, in Wordpad, that the first table has a CREATE TABLE ..... DEFAULT CHARACTERSET latin1 COLLATION latin1_mylanguage_ci . The other tables have nothing for collation, meaning default (swedish).

(5) Therefore a search/replace in wordpad, of 'CHARACTERSET latin1' to 'CHARACTERSET latin1 COLLATION latin1_mylanguage_ci ', for every CREATE TABLE except the first one (which is actually the pattern for the method)

(6) Save, close,

(7) delete database, create database, and import from the sql.

(8) for future database, change in my.ini

default-character-set=latin1
default-collation=latin1_mylanguage_ci

or (8A) download and use mysqladministrator, which has in server variables/advance a collation option and writes it, as above, to my.ini .