Tag Archive

UTF-8 fields in MySQL">About using UTF-8 fields in MySQL

Published on 20 December, 2010 By Danny Froberg

Joshua Thi­jssen writes; I some­times hear: “make every­thing utf-8 in your data­base, and all will be fine”. This so-called advice could not be fur­ther from the truth. Indeed, it will take care of inter­na­tion­al­iza­tion and code-page prob­lems when you use UTF-8, but it comes with a price, which may be too high for you to […]

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 Migrating […]

Get Adobe Flash playerPlugin by wpburn.com wordpress themes