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

Reply via email to