Oleg,
I have been fooling around with this all weekend and I am still unsure of
what is going on. In the connections string I now use
?charset=utf8&use_unicode=1, this seems to get past the original error, now
I am getting caught elsewhere.
When I try to add the offending string to the db I get:
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 20:
ordinal not in range(128)
I may be totally off here, so I want to let you know what I am trying to do.
I am reading data from a file, one piece of data contains a char outside of
the ascii range (0xc3). I need to insert that into the db, the column type
is a varchar(64). I am not sure where to start, I believe the db (MySQL) is
setup correctly using unicode. I am new to python and SQLObject so I an
unsure of the unicode support in both.
Is there a tutorial or something that can help me work this out?
Thanks
Glenn
On Jan 4, 2008 5:32 PM, Oleg Broytmann <[EMAIL PROTECTED]> wrote:
> On Fri, Jan 04, 2008 at 05:08:49PM -0500, Glenn MacGregor wrote:
> > if isinstance(value, unicode):
> > --> return value.encode("ascii")
>
> I guess you are trying to pass unicode to a StringCol. If this is the
> case - for unicode use UnicodeCol.
>
> Oleg.
> --
> Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
> Programmers don't die, they just GOSUB without RETURN.
>
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
