Tag Archive

Migrating MySQL latin1 to utf8 – The process

Published on 8 March, 2010 By Danny Froberg
This entry is part 3 of 4 in the series Migrat­ing MySQL latin1 to utf8

Hav­ing cov­ered the prepa­ra­tion and char­ac­ter set options of per­form­ing a latin1 to utf8 MySQL migra­tion, just how do you per­form the migra­tion cor­rectly. Com­plete story again at Migrat­ing MySQL latin1 to utf8 – The process .

Migrating MySQL latin1 to utf8 – Character Set Options

Published on 3 March, 2010 By Danny Froberg
This entry is part 2 of 4 in the series Migrat­ing MySQL latin1 to utf8

Con­tin­u­ing on from prepa­ra­tion in our MySQL latin1 to utf8 migra­tion let us first under­stand where MySQL uses char­ac­ter sets. MySQL defines the char­ac­ter set at 4 dif­fer­ent lev­els for the struc­ture of data. via Migrat­ing MySQL latin1 to utf8 – Char­ac­ter Set Options

Migrating MySQL latin1 to utf8 – Preparation

Published on 3 March, 2010 By Danny Froberg
This entry is part 1 of 4 in the series Migrat­ing MySQL latin1 to utf8

Before under­tak­ing such migra­tion the first step is a les­son in under­stand­ing more about how latin1 and utf8 work and inter­act in MySQL. latin1 in a com­mon and his­tor­i­cal char­ac­ter set used in MySQL. utf8 first avail­able in MySQL Ver­sion 4.1 is an encod­ing sup­port­ing mul­ti­ple bytes and is the sys­tem default in MySQL 5.0 via […]

Get Adobe Flash playerPlugin by wpburn.com wordpress themes