[Buildbot-devel] 8-bit chars vs. sqlalchemy?

Ian Zimmerman itz at buug.org
Sat Jan 4 05:27:33 UTC 2014


On Sun, 15 Dec 2013 11:01:03 -0500
Charles Lepple <clepple at gmail.com> wrote:

Charles> Maybe someone else can speak to the specifics of sqlalchemy and
Charles> 8-bit characters. The part that caught my eye is that "Fu\xdf"
Charles> (Fuß) is valid ISO 8859-1/15, but not valid UTF-8. Might be a
Charles> red herring, though (I am not familiar with the code that
Charles> printed the error message).

This kind of stuff tends to happen when the sqlalchemy "engine" is
opened with something like this:

mysql://user:password@host/database

instead of this:

mysql://user:password@host/database?charset=utf-8

I think the docs say the default is iso-8859-1, but in fact it is
cp-1252 aka Western.

-- 
Please *no* private copies of mailing list or newsgroup messages.

gpg public key: 2048R/984A8AE4
fingerprint: 7953 ADA1 0E8E AB57 FB79  FFD2 360A 88B2 984A 8AE4
Funny pic: http://bit.ly/ZNE2MX




More information about the devel mailing list