[ODBC][37][1602743955.532975][__handles.c][460] Exit:[SQL_SUCCESS] Environment = 0x564861399380 [ODBC][37][1602743955.533022][SQLSetEnvAttr.c][189] Entry: Environment = 0x564861399380 Attribute = SQL_ATTR_ODBC_VERSION Value = 0x3 StrLen = 4 [ODBC][37][1602743955.533048][SQLSetEnvAttr.c][381] Exit:[SQL_SUCCESS] [ODBC][37][1602743955.533070][SQLAllocHandle.c][377] Entry: Handle Type = 2 Input Handle = 0x564861399380 [ODBC][37][1602743955.533094][SQLAllocHandle.c][493] Exit:[SQL_SUCCESS] Output Handle = 0x564861394b50 [ODBC][37][1602743955.533435][SQLDriverConnectW.c][290] Entry: Connection = 0x564861394b50 Window Hdl = (nil) Str In = [DRIVER={ODBC Driver 17 for SQL Server};SERVER=tcp:127.0.0.1,1433;DATABASE=master;UID=sa;PWD=P@ssw0rd][length = 100 (SQL_NTS)] Str Out = (nil) Str Out Max = 0 Str Out Ptr = (nil) Completion = 0 UNICODE Using encoding ASCII 'UTF-8' and UNICODE 'UTF-16LE' [ODBC][37][1602743955.552048][__handles.c][460] Exit:[SQL_SUCCESS] Environment = 0x5648613e86a0 [ODBC][37][1602743955.552095][SQLGetEnvAttr.c][157] Entry: Environment = 0x5648613e86a0 Attribute = 65002 Value = 0x7ffcb3ba5700 Buffer Len = 128 StrLen = 0x7ffcb3ba569c [ODBC][37][1602743955.552121][SQLGetEnvAttr.c][273] Exit:[SQL_SUCCESS] [ODBC][37][1602743955.552147][SQLFreeHandle.c][220] Entry: Handle Type = 1 Input Handle = 0x5648613e86a0 [ODBC][37][1602743955.552184][SQLDriverConnectW.c][914] Exit:[SQL_SUCCESS_WITH_INFO] Connection Out [[NULL]] [ODBC][37][1602743955.552260][SQLGetInfo.c][236] Entry: Connection = 0x564861394b50 Info Type = SQL_DRIVER_ODBC_VER (77) Info Value = 0x7ffcb3ba8680 Buffer Length = 20 StrLen = 0x7ffcb3ba863c [ODBC][37][1602743955.552289][SQLGetInfo.c][236] Entry: Connection = 0x564861394b50 Info Type = SQL_DESCRIBE_PARAMETER (10002) Info Value = 0x7ffcb3ba863e Buffer Length = 2 StrLen = 0x7ffcb3ba863c [ODBC][37][1602743955.552315][SQLGetInfo.c][236] Entry: Connection = 0x564861394b50 Info Type = SQL_NEED_LONG_DATA_LEN (111) Info Value = 0x7ffcb3ba863e Buffer Length = 2 StrLen = 0x7ffcb3ba863c [ODBC][37][1602743955.552341][SQLAllocHandle.c][540] Entry: Handle Type = 3 Input Handle = 0x564861394b50 [ODBC][37][1602743955.552383][SQLAllocHandle.c][1085] Exit:[SQL_SUCCESS] Output Handle = 0x5648613e86a0 [ODBC][37][1602743955.552413][SQLGetTypeInfo.c][168] Entry: Statement = 0x5648613e86a0 Data Type = SQL_VARCHAR [ODBC][37][1602743955.553943][SQLGetTypeInfo.c][321] Exit:[SQL_SUCCESS] [ODBC][37][1602743955.553978][SQLFetch.c][162] Entry: Statement = 0x5648613e86a0 [ODBC][37][1602743955.554006][SQLFetch.c][352] Exit:[SQL_SUCCESS] [ODBC][37][1602743955.554027][SQLGetData.c][237] Entry: Statement = 0x5648613e86a0 Column Number = 3 Target Type = 4 SQL_INTEGER Buffer Length = 4 Target Value = 0x7ffcb3ba8640 StrLen Or Ind = (nil) [ODBC][37][1602743955.554054][SQLGetData.c][545] Exit:[SQL_SUCCESS] Buffer = [8000] Strlen Or Ind = NULLPTR [ODBC][37][1602743955.554079][SQLFreeStmt.c][144] Entry: Statement = 0x5648613e86a0 Option = 0 [ODBC][37][1602743955.554108][SQLFreeStmt.c][266] Exit:[SQL_SUCCESS] [ODBC][37][1602743955.554134][SQLFreeHandle.c][387] Entry: Handle Type = 3 Input Handle = 0x5648613e86a0 [ODBC][37][1602743955.554163][SQLFreeHandle.c][490] Exit:[SQL_SUCCESS] [ODBC][37][1602743955.554198][SQLAllocHandle.c][540] Entry: Handle Type = 3 Input Handle = 0x564861394b50 [ODBC][37][1602743955.554227][SQLAllocHandle.c][1085] Exit:[SQL_SUCCESS] Output Handle = 0x5648613e86a0 [ODBC][37][1602743955.554253][SQLGetTypeInfo.c][168] Entry: Statement = 0x5648613e86a0 Data Type = Unknown(-9) [ODBC][37][1602743955.556245][SQLGetTypeInfo.c][321] Exit:[SQL_SUCCESS] [ODBC][37][1602743955.556275][SQLFetch.c][162] Entry: Statement = 0x5648613e86a0 [ODBC][37][1602743955.556301][SQLFetch.c][352] Exit:[SQL_SUCCESS] [ODBC][37][1602743955.556322][SQLGetData.c][237] Entry: Statement = 0x5648613e86a0 Column Number = 3 Target Type = 4 SQL_INTEGER Buffer Length = 4 Target Value = 0x7ffcb3ba8644 StrLen Or Ind = (nil) [ODBC][37][1602743955.556354][SQLGetData.c][545] Exit:[SQL_SUCCESS] Buffer = [4000] Strlen Or Ind = NULLPTR [ODBC][37][1602743955.556387][SQLFreeStmt.c][144] Entry: Statement = 0x5648613e86a0 Option = 0 [ODBC][37][1602743955.556416][SQLFreeStmt.c][266] Exit:[SQL_SUCCESS] [ODBC][37][1602743955.556442][SQLFreeHandle.c][387] Entry: Handle Type = 3 Input Handle = 0x5648613e86a0 [ODBC][37][1602743955.556470][SQLFreeHandle.c][490] Exit:[SQL_SUCCESS] [ODBC][37][1602743955.556496][SQLAllocHandle.c][540] Entry: Handle Type = 3 Input Handle = 0x564861394b50 [ODBC][37][1602743955.556524][SQLAllocHandle.c][1085] Exit:[SQL_SUCCESS] Output Handle = 0x5648613e86a0 [ODBC][37][1602743955.556550][SQLGetTypeInfo.c][168] Entry: Statement = 0x5648613e86a0 Data Type = SQL_VARBINARY [ODBC][37][1602743955.558077][SQLGetTypeInfo.c][321] Exit:[SQL_SUCCESS] [ODBC][37][1602743955.558111][SQLFetch.c][162] Entry: Statement = 0x5648613e86a0 [ODBC][37][1602743955.558133][SQLFetch.c][352] Exit:[SQL_SUCCESS] [ODBC][37][1602743955.558152][SQLGetData.c][237] Entry: Statement = 0x5648613e86a0 Column Number = 3 Target Type = 4 SQL_INTEGER Buffer Length = 4 Target Value = 0x7ffcb3ba8648 StrLen Or Ind = (nil) [ODBC][37][1602743955.558172][SQLGetData.c][545] Exit:[SQL_SUCCESS] Buffer = [8000] Strlen Or Ind = NULLPTR [ODBC][37][1602743955.558194][SQLFreeStmt.c][144] Entry: Statement = 0x5648613e86a0 Option = 0 [ODBC][37][1602743955.558210][SQLFreeStmt.c][266] Exit:[SQL_SUCCESS] [ODBC][37][1602743955.558228][SQLFreeHandle.c][387] Entry: Handle Type = 3 Input Handle = 0x5648613e86a0 [ODBC][37][1602743955.558255][SQLFreeHandle.c][490] Exit:[SQL_SUCCESS] [ODBC][37][1602743955.558280][SQLAllocHandle.c][540] Entry: Handle Type = 3 Input Handle = 0x564861394b50 [ODBC][37][1602743955.558308][SQLAllocHandle.c][1085] Exit:[SQL_SUCCESS] Output Handle = 0x5648613e86a0 [ODBC][37][1602743955.558334][SQLGetTypeInfo.c][168] Entry: Statement = 0x5648613e86a0 Data Type = SQL_TYPE_TIMESTAMP [ODBC][37][1602743955.561490][SQLGetTypeInfo.c][321] Exit:[SQL_SUCCESS] [ODBC][37][1602743955.561524][SQLFetch.c][162] Entry: Statement = 0x5648613e86a0 [ODBC][37][1602743955.561538][SQLFetch.c][352] Exit:[SQL_SUCCESS] [ODBC][37][1602743955.561556][SQLGetData.c][237] Entry: Statement = 0x5648613e86a0 Column Number = 3 Target Type = 4 SQL_INTEGER Buffer Length = 4 Target Value = 0x7ffcb3ba864c StrLen Or Ind = (nil) [ODBC][37][1602743955.561633][SQLGetData.c][545] Exit:[SQL_SUCCESS] Buffer = [27] Strlen Or Ind = NULLPTR [ODBC][37][1602743955.561658][SQLFreeStmt.c][144] Entry: Statement = 0x5648613e86a0 Option = 0 [ODBC][37][1602743955.561683][SQLFreeStmt.c][266] Exit:[SQL_SUCCESS] [ODBC][37][1602743955.561708][SQLFreeHandle.c][387] Entry: Handle Type = 3 Input Handle = 0x5648613e86a0 [ODBC][37][1602743955.561737][SQLFreeHandle.c][490] Exit:[SQL_SUCCESS] [ODBC][37][1602743955.561777][SQLAllocHandle.c][540] Entry: Handle Type = 3 Input Handle = 0x564861394b50 [ODBC][37][1602743955.561807][SQLAllocHandle.c][1085] Exit:[SQL_SUCCESS] Output Handle = 0x5648613e86a0 [ODBC][37][1602743955.561839][SQLFreeStmt.c][144] Entry: Statement = 0x5648613e86a0 Option = 0 [ODBC][37][1602743955.561865][SQLFreeStmt.c][266] Exit:[SQL_SUCCESS] [ODBC][37][1602743955.561905][SQLExecDirectW.c][177] Entry: Statement = 0x5648613e86a0 SQL = [CREATE DATABASE pyodbc_test COLLATE Latin1_General_100_CI_AS_SC][length = 63] [ODBC][37][1602743956.211128][SQLExecDirectW.c][456] Exit:[SQL_SUCCESS] [ODBC][37][1602743956.211181][SQLRowCount.c][173] Entry: Statement = 0x5648613e86a0 Row Count = 0x7ffcb3ba8870 [ODBC][37][1602743956.211211][SQLRowCount.c][247] Exit:[SQL_SUCCESS] Row Count = 0x7ffcb3ba8870 -> -1 [ODBC][37][1602743956.211240][SQLNumResultCols.c][156] Entry: Statement = 0x5648613e86a0 Column Count = 0x7ffcb3ba8868 [ODBC][37][1602743956.211264][SQLNumResultCols.c][251] Exit:[SQL_SUCCESS] Count = 0x7ffcb3ba8868 -> 0 [ODBC][37][1602743956.211298][SQLFreeStmt.c][144] Entry: Statement = 0x5648613e86a0 Option = 0 [ODBC][37][1602743956.211322][SQLFreeStmt.c][266] Exit:[SQL_SUCCESS] [ODBC][37][1602743956.211363][SQLExecDirectW.c][177] Entry: Statement = 0x5648613e86a0 SQL = [USE pyodbc_test][length = 15] [ODBC][37][1602743956.212113][SQLExecDirectW.c][456] Exit:[SQL_SUCCESS_WITH_INFO] [ODBC][37][1602743956.212144][SQLRowCount.c][173] Entry: Statement = 0x5648613e86a0 Row Count = 0x7ffcb3ba8870 [ODBC][37][1602743956.212168][SQLRowCount.c][247] Exit:[SQL_SUCCESS] Row Count = 0x7ffcb3ba8870 -> -1 [ODBC][37][1602743956.212189][SQLNumResultCols.c][156] Entry: Statement = 0x5648613e86a0 Column Count = 0x7ffcb3ba8868 [ODBC][37][1602743956.212204][SQLNumResultCols.c][251] Exit:[SQL_SUCCESS] Count = 0x7ffcb3ba8868 -> 0 [ODBC][37][1602743956.212224][SQLFreeStmt.c][144] Entry: Statement = 0x5648613e86a0 Option = 0 [ODBC][37][1602743956.212246][SQLFreeStmt.c][266] Exit:[SQL_SUCCESS] [ODBC][37][1602743956.212275][SQLExecDirectW.c][177] Entry: Statement = 0x5648613e86a0 SQL = [ CREATE TABLE msg ( id int identity(1,1) not null, content varchar(max) not null );][length = 123] [ODBC][37][1602743956.214937][SQLExecDirectW.c][456] Exit:[SQL_SUCCESS] [ODBC][37][1602743956.214970][SQLRowCount.c][173] Entry: Statement = 0x5648613e86a0 Row Count = 0x7ffcb3ba8870 [ODBC][37][1602743956.214993][SQLRowCount.c][247] Exit:[SQL_SUCCESS] Row Count = 0x7ffcb3ba8870 -> -1 [ODBC][37][1602743956.215016][SQLNumResultCols.c][156] Entry: Statement = 0x5648613e86a0 Column Count = 0x7ffcb3ba8868 [ODBC][37][1602743956.215037][SQLNumResultCols.c][251] Exit:[SQL_SUCCESS] Count = 0x7ffcb3ba8868 -> 0 [ODBC][37][1602743956.215059][SQLFreeStmt.c][144] Entry: Statement = 0x5648613e86a0 Option = 0 [ODBC][37][1602743956.215083][SQLFreeStmt.c][266] Exit:[SQL_SUCCESS] [ODBC][37][1602743956.215104][SQLExecDirectW.c][177] Entry: Statement = 0x5648613e86a0 SQL = [ INSERT INTO msg (content) VALUES ('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA...][length = 2047] [ODBC][37][1602743956.217713][SQLExecDirectW.c][456] Exit:[SQL_SUCCESS] [ODBC][37][1602743956.217759][SQLRowCount.c][173] Entry: Statement = 0x5648613e86a0 Row Count = 0x7ffcb3ba8870 [ODBC][37][1602743956.217783][SQLRowCount.c][247] Exit:[SQL_SUCCESS] Row Count = 0x7ffcb3ba8870 -> 1 [ODBC][37][1602743956.217802][SQLNumResultCols.c][156] Entry: Statement = 0x5648613e86a0 Column Count = 0x7ffcb3ba8868 [ODBC][37][1602743956.217818][SQLNumResultCols.c][251] Exit:[SQL_SUCCESS] Count = 0x7ffcb3ba8868 -> 0 [ODBC][37][1602743956.217891][SQLFreeStmt.c][144] Entry: Statement = 0x5648613e86a0 Option = 0 [ODBC][37][1602743956.217909][SQLFreeStmt.c][266] Exit:[SQL_SUCCESS] [ODBC][37][1602743956.217931][SQLPrepareW.c][165] Entry: Statement = 0x5648613e86a0 SQL = [ INSERT INTO msg (content) VALUES (?)][length = 49] [ODBC][37][1602743956.217973][SQLPrepareW.c][346] Exit:[SQL_SUCCESS] [ODBC][37][1602743956.217992][SQLNumParams.c][144] Entry: Statement = 0x5648613e86a0 Param Count = 0x7ffcb3ba8796 [ODBC][37][1602743956.218015][SQLNumParams.c][231] Exit:[SQL_SUCCESS] Count = 0x7ffcb3ba8796 -> 1 [ODBC][37][1602743956.218044][SQLBindParameter.c][217] Entry: Statement = 0x5648613e86a0 Param Number = 1 Param Type = 1 C Type = -8 SQL_C_WCHAR SQL Type = -10 Col Def = 4002 Scale = 0 Rgb Value = 0x564861448eb0 Value Max = 8 StrLen Or Ind = 0x564861448ed8 [ODBC][37][1602743956.218064][SQLBindParameter.c][434] Exit:[SQL_SUCCESS] [ODBC][37][1602743956.218081][SQLExecute.c][187] Entry: Statement = 0x5648613e86a0 [ODBC][37][1602743956.219442][SQLExecute.c][357] Exit:[SQL_NEED_DATA] [ODBC][37][1602743956.219471][SQLParamData.c][166] Entry: Statement = 0x5648613e86a0 Value = 0x7ffcb3ba8868 [ODBC][37][1602743956.219487][SQLParamData.c][362] Exit:[SQL_NEED_DATA] Value = 0x564861448eb0 [ODBC][37][1602743956.219504][SQLPutData.c][148] Entry: Statement = 0x5648613e86a0 Data = 0x56486142bdc0 StrLen = 4000 [ODBC][37][1602743956.219538][SQLPutData.c][315] Exit:[SQL_SUCCESS] [ODBC][37][1602743956.219561][SQLPutData.c][148] Entry: Statement = 0x5648613e86a0 Data = 0x56486142cd60 StrLen = 2 [ODBC][37][1602743956.219635][SQLPutData.c][315] Exit:[SQL_SUCCESS] [ODBC][37][1602743956.219658][SQLParamData.c][166] Entry: Statement = 0x5648613e86a0 Value = 0x7ffcb3ba8868 [ODBC][37][1602743956.220306][SQLParamData.c][362] Exit:[SQL_ERROR] Value = 0x564861448eb0 DIAG [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot convert to text/ntext or collate to 'Latin1_General_100_CI_AS_SC' because these legacy LOB types do not support UTF-8 or UTF-16 encodings. Use types varchar(max), nvarchar(max) or a collation which does not have the _SC or _UTF8 flags. [ODBC][37][1602743956.220352][SQLGetDiagRecW.c][535] Entry: Statement = 0x5648613e86a0 Rec Number = 1 SQLState = 0x7ffcb3ba7fe4 Native = 0x7ffcb3ba7fc4 Message Text = 0x7ffcb3ba7ff0 Buffer Length = 1023 Text Len Ptr = 0x7ffcb3ba7fc2 [ODBC][37][1602743956.220375][SQLGetDiagRecW.c][596] Exit:[SQL_SUCCESS] SQLState = [42000] Native = 0x7ffcb3ba7fc4 -> 4189 Message Text = [[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot convert to text/ntext or collate to 'Latin1_General_100_CI_AS_SC' b] [ODBC][37][1602743956.222838][SQLFreeStmt.c][144] Entry: Statement = 0x5648613e86a0 Option = 0 [ODBC][37][1602743956.222865][SQLFreeStmt.c][266] Exit:[SQL_SUCCESS] [ODBC][37][1602743956.222883][SQLFreeStmt.c][144] Entry: Statement = 0x5648613e86a0 Option = 3 [ODBC][37][1602743956.222931][SQLFreeStmt.c][266] Exit:[SQL_SUCCESS] [ODBC][37][1602743956.222949][SQLFreeHandle.c][387] Entry: Handle Type = 3 Input Handle = 0x5648613e86a0 [ODBC][37][1602743956.223713][SQLFreeHandle.c][490] Exit:[SQL_SUCCESS] [ODBC][37][1602743956.223732][SQLDisconnect.c][208] Entry: Connection = 0x564861394b50 [ODBC][37][1602743956.223835][SQLDisconnect.c][379] Exit:[SQL_SUCCESS] [ODBC][37][1602743956.223858][SQLFreeHandle.c][290] Entry: Handle Type = 2 Input Handle = 0x564861394b50 [ODBC][37][1602743956.223889][SQLFreeHandle.c][339] Exit:[SQL_SUCCESS]