Line data    Source code

       1             : #include "common.h"
       2             : 
       3             : /* test binding with UTF-8 encoding */
       4             : 
       5             : #ifndef _WIN32
       6             : /* test table name, it contains two japanese characters */
       7             : static const char table_name[] = "mytab\xe7\x8e\x8b\xe9\xb4\xbb";
       8             : 
       9             : static const char * const strings[] = {
      10             :         /* ascii */
      11             :         "aaa", "aaa",
      12             :         /* latin 1*/
      13             :         "abc\xc3\xa9\xc3\xa1\xc3\xb4", "abc\xc3\xa9\xc3\xae\xc3\xb4",
      14             :         /* Japanese... */
      15             :         "abc\xe7\x8e\x8b\xe9\xb4\xbb", "abc\xe7\x8e\x8b\xe9\xb4\xbb\xe5\x82\x91\xe7\x8e\x8b\xe9\xb4\xbb\xe5\x82\x91",
      16             :         NULL, NULL
      17             : };
      18             : 
      19             : /* same strings in hex */
      20             : static const char * const strings_hex[] = {
      21             :         /* ascii */
      22             :         "0x610061006100", "0x610061006100",
      23             :         /* latin 1*/
      24             :         "0x610062006300e900e100f400", "0x610062006300e900ee00f400",
      25             :         /* Japanese... */
      26             :         "0x6100620063008b733b9d", "0x6100620063008b733b9d91508b733b9d9150",
      27             :         NULL, NULL
      28             : };
      29             : 
      30             : static char tmp[1024*3];
      31             : 
      32             : static void
      33          16 : TestBinding(int minimun)
      34             : {
      35             :         const char * const*p;
      36             :         SQLINTEGER n;
      37             :         SQLLEN n_len;
      38             : 
      39          16 :         sprintf(tmp, "DELETE FROM %s", table_name);
      40          16 :         odbc_command(tmp);
      41             : 
      42             :         /* insert with SQLPrepare/SQLBindParameter/SQLExecute */
      43          16 :         sprintf(tmp, "INSERT INTO %s VALUES(?,?,?)", table_name);
      44          16 :         CHKPrepare(T(tmp), SQL_NTS, "S");
      45          16 :         CHKBindParameter(1, SQL_PARAM_INPUT, SQL_C_LONG,
      46             :                 SQL_INTEGER, 0, 0, &n, 0, &n_len, "S");
      47          16 :         n_len = sizeof(n);
      48             :         
      49          64 :         for (n = 1, p = strings; p[0] && p[1]; p += 2, ++n) {
      50             :                 SQLLEN s1_len, s2_len;
      51             :                 unsigned int len;
      52             : 
      53          48 :                 len = minimun ? ((int) strlen(strings_hex[p-strings]) - 2) / 4 : 40;
      54          48 :                 CHKBindParameter(2, SQL_PARAM_INPUT, SQL_C_CHAR,
      55             :                         SQL_WCHAR, len, 0, (void *) p[0], 0, &s1_len, "S");
      56          48 :                 len = minimun ? ((int) strlen(strings_hex[p+1-strings]) - 2) / 4 : 40;
      57             :                 /* FIXME this with SQL_VARCHAR produce wrong protocol data */
      58          48 :                 CHKBindParameter(3, SQL_PARAM_INPUT, SQL_C_CHAR,
      59             :                         SQL_WVARCHAR, len, 0, (void *) p[1], 0, &s2_len, "S");
      60          48 :                 s1_len = strlen(p[0]);
      61          48 :                 s2_len = strlen(p[1]);
      62          48 :                 printf("insert #%d\n", (int) n);
      63          48 :                 CHKExecute("S");
      64             :         }
      65             : 
      66             :         /* check rows */
      67          64 :         for (n = 1, p = strings_hex; p[0] && p[1]; p += 2, ++n) {
      68          48 :                 sprintf(tmp, "IF NOT EXISTS(SELECT * FROM %s WHERE k = %d AND c = %s AND vc = %s) SELECT 1", table_name, (int) n, p[0], p[1]);
      69          48 :                 odbc_check_no_row(tmp);
      70             :         }
      71             : 
      72          16 :         odbc_reset_statement();
      73          16 : }
      74             : 
      75          10 : TEST_MAIN()
      76             : {
      77             :         const char * const*p;
      78             :         SQLINTEGER n;
      79             : 
      80          10 :         odbc_use_version3 = 1;
      81          10 :         odbc_conn_additional_params = "ClientCharset=UTF-8;";
      82             : 
      83          10 :         odbc_connect();
      84          10 :         if (!odbc_driver_is_freetds()) {
      85           0 :                 odbc_disconnect();
      86           0 :                 printf("Driver is not FreeTDS, exiting\n");
      87           0 :                 odbc_test_skipped();
      88           0 :                 return 0;
      89             :         }
      90             : 
      91          10 :         if (!odbc_db_is_microsoft() || odbc_db_version_int() < 0x08000000u) {
      92           2 :                 odbc_disconnect();
      93           2 :                 printf("Test for MSSQL only\n");
      94           2 :                 odbc_test_skipped();
      95           0 :                 return 0;
      96             :         }
      97             : 
      98           8 :         CHKAllocStmt(&odbc_stmt, "S");
      99             : 
     100             :         /* create test table */
     101           8 :         sprintf(tmp, "IF OBJECT_ID(N'%s') IS NOT NULL DROP TABLE %s", table_name, table_name);
     102           8 :         odbc_command(tmp);
     103           8 :         sprintf(tmp, "CREATE TABLE %s (k int, c NCHAR(10), vc NVARCHAR(10))", table_name);
     104           8 :         odbc_command(tmp);
     105             : 
     106             :         /* insert with INSERT statements */
     107          32 :         for (n = 1, p = strings; p[0] && p[1]; p += 2, ++n) {
     108          24 :                 sprintf(tmp, "INSERT INTO %s VALUES (%d,N'%s',N'%s')", table_name, (int) n, p[0], p[1]);
     109          24 :                 odbc_command(tmp);
     110             :         }
     111             : 
     112             :         /* check rows */
     113          24 :         for (n = 1, p = strings_hex; p[0] && p[1]; p += 2, ++n) {
     114          24 :                 sprintf(tmp, "IF NOT EXISTS(SELECT * FROM %s WHERE k = %d AND c = %s AND vc = %s) SELECT 1", table_name, (int) n, p[0], p[1]);
     115          24 :                 odbc_check_no_row(tmp);
     116             :         }
     117             : 
     118           8 :         TestBinding(0);
     119             : 
     120           8 :         TestBinding(1);
     121             : 
     122             :         /* cleanup */
     123           8 :         sprintf(tmp, "IF OBJECT_ID(N'%s') IS NOT NULL DROP TABLE %s", table_name, table_name);
     124           8 :         odbc_command(tmp);
     125             : 
     126           8 :         odbc_disconnect();
     127           8 :         printf("Done.\n");
     128           8 :         return 0;
     129             : }
     130             : 
     131             : #else
     132             : 
     133             : TEST_MAIN()
     134             : {
     135             :         /* on Windows SQLExecDirect is always converted to SQLExecDirectW by the DM */
     136             :         printf("Not possible for this platform.\n");
     137             :         odbc_test_skipped();
     138             :         return 0;
     139             : }
     140             : #endif