EmergencyEMERGENCY? Get 24/7 Help Now!

Converting Character Sets

 | March 17, 2009 |  Posted In: Insight for Developers

The web is going the way of utf8. Drizzle has chosen it as the default character set, most back-ends to websites use it to store text data, and those who are still using latin1 have begun to migrate their databases to utf8. Googling for “mysql convert charset to utf8” results in a plethora of sites, […]

Read More

JOIN Performance & Charsets

 | October 21, 2008 | 

We have written before about the importance of using numeric types as keys, but maybe you’ve inherited a schema that you can’t change or have chosen string types as keys for a specific reason. Either way, the character sets used on joined columns can have a significant impact on the performance of your queries. Take […]

Read More