Michael Bayer wrote:
> 
> On Oct 8, 2008, at 8:54 PM, jason kirtland wrote:
> 
>> Most likely you just need to configure the db-api's client encoding by
>> adding ?charset=utf8 onto your connection URL.
>>
>> Enough folks have hit this recently that I'm (again) considering  
>> passing
>> through the engine encoding= parameter to the MySQLdb connection  
>> setup.
>>  I've resisted the urge for a while because we don't to my knowledge
>> re-configure any db-apis in any of the backends.  But this keeps  
>> coming
>> up despite being documented in the mysql section of the docs, and last
>> time I traced through it, it seemed like MySQLdb was ignoring the
>> server's configured connection_encoding so a little assist from the SA
>> side would probably be useful.
>>
>> I'll look at sneaking that into the upcoming rc2 unless the
>> implementation is untenable for some reason or there's an outcry.
> 
> 
> since im a total dumdum, why have i never had this issue in my own  
> dealings with MySQL and Unicode ?   I use the Unicode type, i dont use  
> any charset= on my URL, and things work fine, including all of our  
> unit tests.  Is it actually storing the data incorrectly and we just  
> see the same info at the SQLA round trip level ?

i don't know about your env, but the unit tests under mysql use 
testing.engines.utf8_engine to configure a connection that can send 
unicode across the wire without encoding failures.


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to