I was trying to copy a MS Sql server database to a Sqlite database
(with SA 5.8), and get this exception:

 return typeobj.adapt(impltype)
  File "C:\Python25\lib\site-packages\sqlalchemy\databases\mssql.py",
line 685, in adapt
    collation=self.collation)
TypeError: __init__() got an unexpected keyword argument 'collation'

I looked it up and changed SA's code like this:
file changed: \PythonXX\Lib\site-packages\sqlalchemy\types.py
changed a method of the class String:
   orig :       def __init__(self, length=None, convert_unicode=False,
assert_unicode=None):
                     ..........
                     ..........
   modified: def __init__(self, length=None, convert_unicode=False,
assert_unicode=None,collation = None):
                     ........
                     ........
                     self.collation = collation
and this worked fine for me, but the cloned database on sqlite still
lost all collations.

Wondering if there is any other way to work around this issue.

Thanks a lot!


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

Reply via email to