I am using mysqldb-1.2.2. I am passing 'SET NAMES' to connect method as a value for "init_command" parameter. All tables have utf8 charset. And I pass convert_unicode=True to engine.
Let me know if anything else is required. thanks! On 8/15/07, jason kirtland <[EMAIL PROTECTED]> wrote: > > > So to recap, you are setting the character set on the dbapi > connection via the MySQLdb method in addition to issuing a manual > SET NAMES query? > > > Arun wrote: > > Any other clue that may be helpful in troubleshooting the cause ? > > > > > > On 8/15/07, Arun Kumar PG <[EMAIL PROTECTED] > wrote: > > > > Yes. it's being done. I create the engine and then set convert > > unicode = True. > > > > > > > > On 8/15/07, Michael Bayer < [EMAIL PROTECTED]> wrote: > > > > > > are you using convert_unicode=True and/or the Unicode type ? > > > > > > > > On Aug 15, 2007, at 12:01 PM, Arun Kumar PG wrote: > > > > All tables are having a charset of utf8. Additionally, I am > > issuing SET NAMES 'utf8' statement as a part of connection > > establishment. > > > > Anything that is wrong here or missing ? > > > > > > On 8/15/07, jason kirtland <[EMAIL PROTECTED]> wrote: > > > > > > Arun Kumar PG wrote: > >> Hi All, > >> > >> Recently I upgraded to the version 3.9 of SA. Post that whenever > >> I am trying to save characters in different language in the > >> table I am getting the below exception: > >> > >> File "/src/sqlalchemy/engine/base.py", > >> line 601, in _execute > >> raise exceptions.SQLError(context.statement, context.parameters, > >> e) SQLError: (UnicodeDecodeError) 'ascii' codec can't decode > >> byte 0xc3 in position 1: ordinal not in range(128) > >> > >> I am wondering why it is using ascii codec instead of unicode ? > >> > >> FYI: I am using MySQL 4.1 and the charset of table is utf-8. > > > > Odd to see ascii there instead of latin1. Is your database > > configured > > for utf-8 client connections? > > > > > > > > > > > > > > -- > > Cheers, > > > > - A > > > > > > > > > > > > > > > > > > > > > > -- > > Cheers, > > > > - A > > > > > > -- Cheers, - A --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---