http://snipplr.com/favorites/jamesming/tags/character Recent snippets posted on Snipplr.com en-us Mon, 20 May 2013 10:57:08 GMT http://snipplr.com/view/12860/correcting-wrong-character-encoding-in-mysql-data/ When you forget to "SET NAMES utf8", you'll probably end up with a bunch of latin1 data in your utf8 column. This query fixes that, CONVERTing the existing data to its correct collation.

]]> Fri, 06 Mar 2009 21:30:47 GMT http://snipplr.com/view/12860/correcting-wrong-character-encoding-in-mysql-data/ http://snipplr.com/view/4935/cleaning-a-string/ Wandelt eine Zeichenkette, die Sonderzeichen enthält, in eine Zeichenkette ohne Sonderzeichen. Converts a string, the special characters contains in a string without special characters.

]]> Thu, 07 Feb 2008 07:55:58 GMT http://snipplr.com/view/4935/cleaning-a-string/