** iODBC Trace file ** Trace started on Thu Nov 22 16:27:20 2007 ** Driver Manager: 03.52.0607.1008 [000000.000495] Application 8009AE640 ENTER SQLAllocHandle SQLSMALLINT 1 (SQL_HANDLE_ENV) SQLHANDLE 0x0 (SQL_NULL_HANDLE) SQLHANDLE * 0x7fffffffe8d8 [000000.000636] Application 8009AE640 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 1 (SQL_HANDLE_ENV) SQLHANDLE 0x0 (SQL_NULL_HANDLE) SQLHANDLE * 0x7fffffffe8d8 (0x800c10150) [000000.000772] Application 8009AE640 ENTER SQLSetEnvAttr SQLHENV 0x800c10150 SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION) SQLPOINTER 0x3 SQLINTEGER * 0 [000000.000930] Application 8009AE640 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS) SQLHENV 0x800c10150 SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION) SQLPOINTER 0x3 SQLINTEGER * 0 [000000.001080] Application 8009AE640 ENTER SQLAllocHandle SQLSMALLINT 2 (SQL_HANDLE_DBC) SQLHANDLE 0x800c10150 SQLHANDLE * 0x7fffffffe8d0 [000000.001233] Application 8009AE640 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 (SQL_HANDLE_DBC) SQLHANDLE 0x800c10150 SQLHANDLE * 0x7fffffffe8d0 (0x800c70200) [000000.001370] Application 8009AE640 ENTER SQLDriverConnect SQLHDBC 0x800c70200 SQLPOINTER 0x0 SQLCHAR * 0x400d18 | DSN=mysqldb; | SQLSMALLINT -3 (SQL_NTS) SQLCHAR * 0x7fffffffe4c0 SQLSMALLINT 1024 SQLSMALLINT * 0x7fffffffe4be SQLUSMALLINT 1 (SQL_DRIVER_COMPLETE) [000000.028319] Application 8009AE640 EXIT SQLDriverConnect with return code 0 (SQL_SUCCESS) SQLHDBC 0x800c70200 SQLPOINTER 0x0 SQLCHAR * 0x400d18 SQLSMALLINT -3 (SQL_NTS) SQLCHAR * 0x7fffffffe4c0 | DSN=mysqldb;SERVER=127.0.0.1;UID=miracee | | ;DATABASE=test;PORT=3306;CHARSET=utf8 | SQLSMALLINT 1024 SQLSMALLINT * 0x7fffffffe4be (77) SQLUSMALLINT 1 (SQL_DRIVER_COMPLETE) [000000.028880] Application 8009AE640 ENTER SQLAllocHandle SQLSMALLINT 3 (SQL_HANDLE_STMT) SQLHANDLE 0x800c70200 SQLHANDLE * 0x7fffffffe4b0 [000000.029271] Application 8009AE640 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 3 (SQL_HANDLE_STMT) SQLHANDLE 0x800c70200 SQLHANDLE * 0x7fffffffe4b0 (0x800d501a0) [000000.029412] Application 8009AE640 ENTER SQLExecDirect SQLHSTMT 0x800d501a0 SQLCHAR * 0x400d70 | create database if not exists utf8test c | | haracter set utf8 collate utf8_unicode_c | | i | SQLINTEGER -3 (SQL_NTS) [000000.030837] Application 8009AE640 EXIT SQLExecDirect with return code 0 (SQL_SUCCESS) SQLHSTMT 0x800d501a0 SQLCHAR * 0x400d70 SQLINTEGER -3 (SQL_NTS) [000000.030997] Application 8009AE640 ENTER SQLAllocHandle SQLSMALLINT 3 (SQL_HANDLE_STMT) SQLHANDLE 0x800c70200 SQLHANDLE * 0x7fffffffe498 [000000.031358] Application 8009AE640 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 3 (SQL_HANDLE_STMT) SQLHANDLE 0x800c70200 SQLHANDLE * 0x7fffffffe498 (0x800d50300) [000000.031497] Application 8009AE640 ENTER SQLExecDirect SQLHSTMT 0x800d50300 SQLCHAR * 0x400e08 | create table if not exists utf8test.utf8 | | (id serial, t text, v varchar(100), c ch | | ar(100), primary key(id)) | SQLINTEGER -3 (SQL_NTS) [000000.035735] Application 8009AE640 EXIT SQLExecDirect with return code 0 (SQL_SUCCESS) SQLHSTMT 0x800d50300 SQLCHAR * 0x400e08 SQLINTEGER -3 (SQL_NTS) [000000.035902] Application 8009AE640 ENTER SQLFreeHandle SQLSMALLINT 3 (SQL_HANDLE_STMT) SQLHSTMT 0x800d50300 [000000.036040] Application 8009AE640 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 3 (SQL_HANDLE_STMT) SQLHSTMT 0x800d50300 [000000.036199] Application 8009AE640 ENTER SQLAllocHandle SQLSMALLINT 3 (SQL_HANDLE_STMT) SQLHANDLE 0x800c70200 SQLHANDLE * 0x7fffffffe480 [000000.036355] Application 8009AE640 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 3 (SQL_HANDLE_STMT) SQLHANDLE 0x800c70200 SQLHANDLE * 0x7fffffffe480 (0x800d50300) [000000.036859] Application 8009AE640 ENTER SQLExecDirect SQLHSTMT 0x800d50300 SQLCHAR * 0x400ec0 | insert into utf8test.utf8(t, v, c) value | | s('äöüß','äöüß','äöüß') | SQLINTEGER -3 (SQL_NTS) [000000.038466] Application 8009AE640 EXIT SQLExecDirect with return code 0 (SQL_SUCCESS) SQLHSTMT 0x800d50300 SQLCHAR * 0x400ec0 SQLINTEGER -3 (SQL_NTS) [000000.038624] Application 8009AE640 ENTER SQLExecDirect SQLHSTMT 0x800d50300 SQLCHAR * 0x400f10 | insert into utf8test.utf8(t, v, c) value | | s('ÄÖÜSZ','ÄÖÜSZ','ÄÖÜSZ') | SQLINTEGER -3 (SQL_NTS) [000000.039464] Application 8009AE640 EXIT SQLExecDirect with return code 0 (SQL_SUCCESS) SQLHSTMT 0x800d50300 SQLCHAR * 0x400f10 SQLINTEGER -3 (SQL_NTS) [000000.039621] Application 8009AE640 ENTER SQLFreeHandle SQLSMALLINT 3 (SQL_HANDLE_STMT) SQLHSTMT 0x800d50300 [000000.039750] Application 8009AE640 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 3 (SQL_HANDLE_STMT) SQLHSTMT 0x800d50300 [000000.039870] Application 8009AE640 ENTER SQLDisconnect SQLHDBC 0x800c70200 [000000.040464] Application 8009AE640 EXIT SQLDisconnect with return code 0 (SQL_SUCCESS) SQLHDBC 0x800c70200 [000000.040562] Application 8009AE640 ENTER SQLFreeHandle SQLSMALLINT 2 (SQL_HANDLE_DBC) SQLHDBC 0x800c70200 [000000.040741] Application 8009AE640 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 (SQL_HANDLE_DBC) SQLHDBC 0x800c70200 [000000.040855] Application 8009AE640 ENTER SQLFreeHandle SQLSMALLINT 1 (SQL_HANDLE_ENV) SQLHENV 0x800c10150 [000000.040968] Application 8009AE640 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 1 (SQL_HANDLE_ENV) SQLHENV 0x800c10150 ** Trace finished on Thu Nov 22 16:27:20 2007