On Jul 25, 2008, at 5:34 AM, Raoul Snyman wrote:
I'm writing a Pylons app, connecting to an existing oldish database,
and while connecting from my Mac desktop everything is fine, but when
I connect from our dev server, I get the following error:
LookupError: unknown encoding: latin1_swedish_ci
I've done some Googling, found a couple of posts on here, as well as
elsewhere, and I'm not sure what they're talking about in those posts
(specifically, I don't see how they solved the problem).
Hi Raoul,
I'd guess that this error is coming from Python's codecs module,
probably indirectly from a call to unicode() with the encoding param
set to 'latin1_swedish_ci'.
It looks like that's the default for MySQL installations:
http://dev.mysql.com/doc/refman/5.0/en/charset-we-sets.html
But Python's never heard of it:
http://docs.python.org/lib/standard-encodings.html
import codecs
codecs.lookup(latin1_swedish_ci)
Traceback (most recent call last):
File stdin, line 1, in module
LookupError: unknown encoding: latin1_swedish_ci
So my guess is that SA is reading the encoding from the database and
then trying to convert text fields to Unicode and getting the error
above. Why this happens on one box and not another is mysterious. I'm
also on a Mac and it knows nothing about latin1_swedish_ci, so I don't
know why yours would be any different. Has your Mac Python perhaps
been compiled with some MySQL-awareness? If you run this at the
command line on your Mac, what does it report?
python -c import codecs; codecs.lookup('latin1_swedish_ci')
Cheers
Philip
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
