I finally got the encoding to work. I moved from linux to windows,
and now the encoding works with both pymssql and pyodbc.
So it had to do with using FreeTDS. I experimented with FreeTDS.conf
to use version 7.0 and 8.0 and various charsets, but could not get it
to work, so I'll man up and use windows.
db = create_engine('mssql://./test', module=pyodbc,
module_name='pyodbc')
On Apr 11, 11:50 am, "Rick Morrison" <[EMAIL PROTECTED]> wrote:
> Last I heard, pyodbc was working on any POSIX system that supports odbc
> (most likely via unixodbc or iodbc)
>
> http://sourceforge.net/projects/pyodbc/
>
> -- check out the supported platforms
>
> On 4/11/07, Marco Mariani <[EMAIL PROTECTED]> wrote:
>
>
>
> > Rick Morrison wrote:
> > > ...and while I'm making this thread unnecessarily long, I should add
> > > that while pymssql may not understand Unicode data, the pyodbc DB-API
> > > interface does. Thanks to recent work by Paul Johnston, it's on
> > > fast-track to becoming the preferred MSSQL db-api for SA.
>
> > Since he starts with "unfortunately, we have a ms sql server at work",
> > maybe he's not developing on windows, and pyodbc is windows-specific.
>
> > I think the data could be encoded with the 1252 charset, which is
> > similar to 8859-1 but has an apostrophe in chr(146)
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
