This might be a stupid question, but you didn't include the full source of
PrimaryDef, so I have to ask.
How did you define the column? If you set a StringCol instead of a
UnicodeCol, that might explain it.
Also, noe that your second example,
"PrimaryDef(lemma=u"λήμμα῾῾).encode("utf-8")"
does the encoding only after trying to add to the table. Maybe you intended
to write
"PrimaryDef(lemma=u"λήμμα῾῾.encode("utf-8"))"
instead?
Cheers,
Imri
On Sun, Jun 28, 2009 at 4:22 AM, Markos Kapes <mka...@gmail.com> wrote:
> OK, so I have a simple object:
> class PrimaryDef(SQLObject):
> _connection=sqlobject.connectionForURI("mysql://
> infoshopkee...@localhost/lexiko?
> use_unicode=1&charset=utf8&sqlobject_encoding=utf-8")
> class sqlmeta:
> fromDatabase=True
> If I try to add an ascii record, it works.
> If I try to add a unicode record
> PrimaryDef(lemma=u"λήμμα῾῾)
> or even
> PrimaryDef(lemma=u"λήμμα῾῾).encode("utf-8")
> I get the standard
> /opt/local/Library/Frameworks/Python.framework/Versions/2.5/lib/
> python2.5/site-packages/sqlobject/dbconnection.pyc in _insertSQL(self,
> table, names, values)
> 383 return ("INSERT INTO %s (%s) VALUES (%s)" %
> 384 (table, ', '.join(names),
> --> 385 ', '.join([self.sqlrepr(v) for v in values])))
> 386
> 387 def transaction(self):
>
> UnicodeDecodeError: 'ascii' codec can't decode byte 0xce in position
> 1: ordinal not in range(128)
>
> So far so good, I'm still thinking that the connection isn't getting
> my option keys to know it's supposed to be unicode an then chokes at
> sqlrepr, but if I just do
> PrimaryDef._connection.sqlrepr(u"λήμμα῾῾)
> it gives me
> "'\xce\xbb\xce\xae\xce\xbc\xce\xbc\xce\xb1'"
>
> What am I missing here? the table is utf8, the dbencoding is utf8, I'm
> even on OS X, which is utf8.... what gives?
> Thanks for any help.
> --Marko
>
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> sqlobject-discuss mailing list
> sqlobject-discuss@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>
--
Imri Goldberg
--------------------------------------
www.algorithm.co.il/blogs/
--------------------------------------
-- insert signature here ----
------------------------------------------------------------------------------
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
