Re: [SQLObject] Unicode characters

[Glenn M. <gle...@gm...>]

Oleg,

I am looking in svn at col.py, it seems that from_python in the
StringValidator class still uses ascii encoding exclusivly:

class StringValidator(validators.Validator):

    def to_python(self, value, state):
        if value is None:
            return None
        if isinstance(value, unicode):
            connection = state.soObject._connection
            dbEncoding = getattr(connection, "dbEncoding", None) or "ascii"
            return value.encode(dbEncoding)
        return value

    def from_python(self, value, state):
        if value is None:
            return None
        if isinstance(value, str):
            return value
        if isinstance(value, unicode):
-->            return value.encode("ascii")
        return value


Maybe I should not be getting there but I am. I am sure mysqld is set
to utf8 and the connection
is defaulted to utf8 as well.

Thanks

 Glenn



On Jan 4, 2008 4:21 PM, Oleg Broytmann <ph...@ph...> wrote:

> Please, do not top-post.
>
> On Fri, Jan 04, 2008 at 04:15:09PM -0500, Glenn MacGregor wrote:
> > Looking into this issue a bit more revealed that in the StringValidator
> > class, line 505 on col.py, the from_python function tries to encode all
> > unicode type strings to ascii. Is this correct behavior? If so how can I
> get
> > around it ?
>
>   What version of SQLObject? In the latest version the encoding is not
> 'ascii' - the code is
>
>            dbEncoding = getattr(connection, "dbEncoding", None) or "ascii"
>
>   so to change the encoding (on MySQL) you have to set it in the DB URI:
>
> mysql://host:port/database?charset=utf-8
>                           ^^^^^^^^^^^^^
>
> Oleg.
> --
>     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
>           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
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>