public marks

PUBLIC MARKS from hobbes with tags utf-8 & conversion

08 May 2007 00:30

Mysql database migration and special characters | Orthogonal Thought

by 2 others (via)
So, I keep having all sorts of problems when moving my mysql database from one machine to another. The issue is that in text or varchar columns containing data that have special characters like smart quotes (those crazy curly quotes), accented letters, etc. result in scrambled data. For example the following phrase

hobbes's TAGS related to tag utf-8

caractères +   conversion +   convert +   encodage +   mysql +   php +   script +   web +