Hello. I'm using Microsoft Sql Server 2008, sqlalchemy 0.7.1.
When I'm trying to create table using metadata.create_all method with checkfirst=True, an axception is raised. I set option convert_unicode=True in engine initialization. Here is the backtrace: ... File "...", line 32, in _dropTables checkfirst=True) File "C:\Programs\x64\python\lib\site-packages\sqlalchemy\schema.py", line 2442, in drop_all tables=tables) File "C:\Programs\x64\python\lib\site-packages\sqlalchemy\engine\base.py", line 2178, in _run_visitor conn._run_visitor(visitorcallable, element, **kwargs) File "C:\Programs\x64\python\lib\site-packages\sqlalchemy\engine\base.py", line 1857, in _run_visitor **kwargs).traverse_single(element) File "C:\Programs\x64\python\lib\site-packages\sqlalchemy\sql\visitors.py", line 86, in traverse_single return meth(obj, **kw) File "C:\Programs\x64\python\lib\site-packages\sqlalchemy\engine\ddl.py", line 114, in visit_metadata if self._can_drop_table(t)] File "C:\Programs\x64\python\lib\site-packages\sqlalchemy\engine\ddl.py", line 137, in _can_drop_table table.name, schema=table.schema) File "C:\Programs\x64\python\lib\site-packages\sqlalchemy\dialects\mssql\base.py", line 1141, in has_table c = connection.execute(s) File "C:\Programs\x64\python\lib\site-packages\sqlalchemy\engine\base.py", line 1358, in execute params) File "C:\Programs\x64\python\lib\site-packages\sqlalchemy\engine\base.py", line 1491, in _execute_clauseelement compiled_sql, distilled_params File "C:\Programs\x64\python\lib\site-packages\sqlalchemy\engine\base.py", line 1599, in _execute_context context) File "C:\Programs\x64\python\lib\site-packages\sqlalchemy\engine\base.py", line 1592, in _execute_context context) File "C:\Programs\x64\python\lib\site-packages\sqlalchemy\engine\default.py", line 325, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.ProgrammingError: (ProgrammingError) ('42000', '[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]The data types nvarchar and ntext are incompatible in the equal to operator. (402) (SQLExecDirectW); [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (8180)') u'SELECT [COLUMNS_1].[TABLE_SCHEMA], [COLUMNS_1].[TABLE_NAME], [COLUMNS_1].[COLUMN_NAME], [COLUMNS_1].[IS_NULLABLE], [COLUMNS_1].[DATA_TYPE], [COLUMNS_1].[ORDINAL_POSITION], [COLUMNS_1].[CHARACTER_MAXIMUM_LENGTH], [COLUMNS_1].[NUMERIC_PRECISION], [COLUMNS_1].[NUMERIC_SCALE], [COLUMNS_1].[COLUMN_DEFAULT], [COLUMNS_1].[COLLATION_NAME] \nFROM [INFORMATION_SCHEMA].[COLUMNS] AS [COLUMNS_1] \nWHERE [COLUMNS_1].[TABLE_NAME] = ? AND [COLUMNS_1].[TABLE_SCHEMA] = ?' (u'table_name', u'schema_name') When I execute this query in SSMS, everything is OK: SELECT [COLUMNS_1].[TABLE_SCHEMA], [COLUMNS_1].[TABLE_NAME], [COLUMNS_1].[COLUMN_NAME], [COLUMNS_1].[IS_NULLABLE], [COLUMNS_1].[DATA_TYPE], [COLUMNS_1].[ORDINAL_POSITION], [COLUMNS_1].[CHARACTER_MAXIMUM_LENGTH], [COLUMNS_1].[NUMERIC_PRECISION], [COLUMNS_1].[NUMERIC_SCALE], [COLUMNS_1].[COLUMN_DEFAULT], [COLUMNS_1].[COLLATION_NAME] FROM [INFORMATION_SCHEMA].[COLUMNS] AS [COLUMNS_1] WHERE [COLUMNS_1].[TABLE_NAME] = N'table_name' AND [COLUMNS_1].[TABLE_SCHEMA] = N'schema_name' Is there a way to solve this problem? Thank you. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/MtJPM10Rv8gJ. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.