.::ich-wars-nicht.ch::.

Change MySQL Database Encoding

18.06.2010

After getting the MySQL Database encoding, you might want to change it.

To change table column encoding:

ALTER TABLE artists
CHANGE [fieldname] [fieldname] [fieldtype]
CHARACTER SET [encoding]
COLLATE [collation];

To change table encoding:

ALTER TABLE [tablename]
CONVERT TO CHARACTER SET [encoding]
COLLATE [collation];

To change database encoding:

ALTER DATABASE [dbname]
CHARACTER SET [encoding]
COLLATE [collation];

Geschrieben von: danilo
Trackback URL

Possibly related posts:

Kategorien:

helligusvart hat am 18.06.2010 um 11:10 kommentiert:

[New Post] Change MySQL Database Encoding – via #twitoaster http://blog.ich-wars-nicht.ch/2010/06/ch...