djangoproject.com | python.org | nginx.org
version seven.
  http://demongin.org
demongin.org - ASCII and the Editor

ASCII and the Editor

Mysterious encoding gums up the works.


Tuesday, 2008-03-25 | Programming

It was a Sprawl voice and a Sprawl joke.

This post, while entered manually with ye olde MySQL monitor, is the test case for odd ASCII formatting.

We ran into a certain problem while working on http://curseofiga.com that was easy to diagnose and is proving difficult to fix (with conventional means--extreme hacks have yet to be attempted). When cutting and pasting text from a browser, mysterious encoding marks managed to get into the textbox and thus into the SQL query and thus caused the query to fail.

As I work on solving this problem here, I am going to attempt to cut and paste weird stuff (e.g. accent aigus, umlauts, Windows-style carriage returns) into into the textbox and see if I can't develop a method for handling it.