UTF-8 and MySQL
I am still in the process of moving the sites from my old host to DreamHost. One of the sites is one I host for a fellow artist. After doing the regular MySQL dump, and loading this dump into the new database, all unicode characters were, to say it in proper english, fucked up. Luckily, MySQL has some options to set the character encoding for the queries. It didn't completely solve the problem, but at least helped. I ended up using the following command to import the database:mysql -usomethingorother -p --default-character-set=UTF8 --host=databasehostIwantedtoimportto databasename < backup.sql
This solved 99% of the problems. There were still some small problems with specific characters, but overall, everything worked fine. Long live MySQL
September 15, 2006 - tags: technology
Comments
tilting patio umbrella: I'm still learning from you, however I'm improving myself. I definitely love studying every little thing that is written on your blog.Preserve the stories coming. I cherished it!March 8, 2012
LED spotlight: This is a smart blog. I mean it. You have so much knowledge about this issue, and so much passion. 
March 14, 2012
granite countertop toronto granite countertop toronto: The MySQL development project has made its source code available under the terms of the GNU general public license, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for profit firm, the dwedish company MySQL AB, now owned by oracle corporation. Thanks a lot.March 29, 2012
michael furniture : I'm typically to blogging and i really admire your content. The article has actually peaks my interest. I'm going to bookmark your website and preserve checking for brand new information.April 19, 2012
Upcoming events
05-06-2012: Forum PHP
06-06-2012: Symfony Live Paris 2012 07-06-2012: Symfony Live Paris 2012 08-06-2012: Symfony Live Paris 2012 09-06-2012: Symfony Live Paris 2012 23-06-2012: PHP TestFest NL