MySQL Reference Manual: Converting 4.0 Character Columns to 4.1 Format. When transferring my site to TextDrive (my old host uses MySQL 4.0 and TextDrive uses 4.1) I kept running into problems when trying to make MySQL understand some Unicode. I used this as my test post -- some characters would be converted correctly and others would wind up as question marks. I never figured out exactly why my data was being trashed, so I gave up trying to make my columns in MySQL 4.1 work as UTF8 columns, and went back to essentially how I was doing things in 4.0, having MySQL assume my data is latin1, but storing UTF8 data in the columns anyway.
Saturday, February 12, 2005
Permalink
Feel free to post a comment below. Please see my comment policy.
Formatting Rules (No HTML):