Tag Archives: encoding

SMS: circonflexe => 70 caractères!

[en]Did you know that using common French caracters such as ç, ê, ô (and others) made your phone switch encodings, thus reducing the maximum length of your text messages to 70 characters, or less?[fr]Saviez-vous que le jeu de caractères à … Continue reading

Posted in Technology | Tagged encodage, encoding, gsm, iPhone, length, sms, text message, utf-16, utf-8 | 9 Comments

Invalid argument supplied for foreach() in wp-capabilities.php: Case Cracked!

[fr]Le problème avec wp-capabilities.php qui fait qu’on peut se retrouver “exfermé” (enfermé dehors) de son blog WordPress (typiquement en cas de changement de serveur) semble avoir sa source dans le contenu du champ wp_user_roles dans la table wp_options. En particulier, … Continue reading

Posted in Wordpress | Tagged abonné, accent, admin, character, database, dump, encoding, error, foreach, mysql, php, phpmyadmin, rights, role, server, transfer, user, utf-8, warning, Weblog Technology, Wordpress, wp-admin, wp-capabilities.php, wp-db.php, wp_options, wp_user_roles | 34 Comments

Michael Hampton is My Hero of the Day

[fr]En principe, les problèmes de serveur sont résolus. Retour à la normale aussi vite que j’arrive à transférer les données avec la connection wifi très approximative que nous avons ici.[en]Michael Hampton, also known as io_error just saved my life today … Continue reading

Posted in Connected Life, Wordpress | Tagged conference, danahboyd, dreamhost, encoding, Events, Geek / Technical, leweb3, michaelhampton, mysql, Online Culture, paris, php, server, Weblog Technology, Wordpress | 6 Comments

Finally out of MySQL encoding hell

[fr]Description de comment je me suis sortie des problèmes d’encodage qui résultaient en l’affichage de hiéroglyphes sur tous les sites hébergés sur mon serveur.[en]It took weeks, mainly because I was busy with a car accident and the end of school, … Continue reading

Tagged Code and Markup, conversion, database, encodage, encoding, iso-8859-1, latin-1, mysql, problem, problème, python, rendering, script, utf-8, utf8, vim | 5 Comments

Problèmes d’encodage MySQL

Un joli mélange de latin-1 et d’utf-8 dans ma base de données. Un script python pour nettoyer tout ça.

Continue reading
Tagged encoding, latin-1, mysql, python, Real Live Code, scripts, Software and Tools, utf-8 | 11 Comments

Converting MySQL Database Contents to UTF-8

I finally managed to convert my WordPress database content to UTF-8. It’s easy to do, but it wasn’t easy to figure out.

Continue reading
Posted in Wordpress | Tagged command line, convert, database, encoding, error, iso-8859-1, latin-1, max_allowed_packet, mysql, Real Live Code, restart, utf-8, Weblog Technology, Wordpress | 95 Comments