[TurboGears] Encoding Problem with MSSQL

[Miguel Saez]

Please excuse me if this has already been discused.

I'm using SQLAlchemy on a new project under Turbogears. Our database model is partly done, since we are actually making a new version of an old product. That's the main reason why we've chosen SQLAlchemy, since I read it may be more configurable and adaptable than SQLObject.

My problem right now is related to encodings. I'm being able to insert unicode values to the database, but not reading. Even though I can insert unicode values, it is not being done really properly, as a 'ñ' character is being persisted as '+¦'.

When trying to read this values I get an exeption saying: UnicodeDecodeError: 'utf8' codec can't decode bytes in position 9-10: invalid data.

Has anyone been working with SQLAlchemy + MSSQL 2000?

Any adviced will be appreciated.

Thanks!

Miguel


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbogears@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/turbogears
-~----------~----~----~----~------~----~------~--~---