2007/8/13, Paul Johnston <[EMAIL PROTECTED]>: > Chris, > > Good find. For now, I suggest you edit mssql.py and change > MSSQLDialect_pyodbc.supports_unicode_statements to return > False. Or even something list "os.name == 'winnt'".
Thanks, that will save me some time :-) > > Longer term, if PyODBC can support unicode statements on Unix, that's > amazing! Having a look at the implementation, the problem comes from that SQLWCHAR, define in sqltypes.h is not wchar_t in some cases (not mine at least). This lead to a 2 bytes-wide characters string read like a simple char* string. Then the statement sent to the server is only "S"... To fix all this, one has to have a better understanding of how [unix|i]ODBC handle unicode. Regards, Christophe --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
