Re: UNICODE support

On 26/03/16 17:31, Igor Korot wrote:
> Hi, Nick,
>
> On Sat, Mar 26, 2016 at 12:58 PM, Nick Gorham <[email protected]> wrote:
>> On 26/03/16 15:10, Igor Korot wrote:
>>> Hi, (Nick),
>>> Is it enough to do:
>>>
>>> #define UNICODE
>>>
>>> in order to use SQLW-types and functions?
>>>
>>> Or I need to define something else?
>>>
>>> Thank you.
>>> _______________________________________________
>>> unixODBC-dev mailing list
>>> [email protected]
>>> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev
>> You should just be able to use them. Whats not working?
> Check the following code:
>
> [code]
> /* odbc.c
>
>      testing unixODBC
> */
> #include <stdlib.h>
> #include <stdio.h>
> #include <odbcinst.h>
> #include <sqlext.h>
>
> #define SQL_WCHART_CONVERT
>
> int main(int argc,char *argv[])
> {
>      SQLHENV m_henv;
>      SQLSMALLINT i = 1, attr_ret;
>      SQLWCHAR driverDesc[1024], driverAttributes[256],
> dsn[SQL_MAX_DSN_LENGTH + 1], sqlState[20],
> errMsg[SQL_MAX_MESSAGE_LENGTH], dsnDescr[255];
>      SWORD pcbDSN, pcbDesc;
>      SQLINTEGER nativeError;
>      SQLSMALLINT cbErrorMsg, descriptionLength;
>      SQLUSMALLINT direction = SQL_FETCH_FIRST, direct = SQL_FETCH_FIRST;
>
>      RETCODE ret = SQLAllocHandle( SQL_HANDLE_ENV, SQL_NULL_HENV, &m_henv );
>      if( ret != SQL_SUCCESS && ret != SQL_SUCCESS_WITH_INFO )
>      {
>          printf( "Error allocating handle\r\n" );
>          while( ( ret = SQLGetDiagRecW( SQL_HANDLE_ENV, m_henv, i,
> sqlState, &nativeError, errMsg, sizeof( errMsg ), &cbErrorMsg ) ) ==
> SQL_SUCCESS )
>          {
>              printf( "Error is: %s\r\n", errMsg );
>          }
>          exit( 0 );
>      }
>      else
>      {
>          ret = SQLSetEnvAttr( m_henv, SQL_ATTR_ODBC_VERSION, (void *)
> SQL_OV_ODBC3, 0 );
>          if( ret != SQL_SUCCESS && ret != SQL_SUCCESS_WITH_INFO )
>          {
>              printf( "Error setting environment\r\n" );
>              while( ( ret = SQLGetDiagRec( SQL_HANDLE_ENV, m_henv, i,
> sqlState, &nativeError, errMsg, sizeof( errMsg ), &cbErrorMsg ) ) ==
> SQL_SUCCESS )
>              {
>                  printf( "Error is: %s\r\n", errMsg );
>              }
>              exit( 0 );
>          }
>          else
>          {
>              while( ( ret = SQLDrivers( m_henv, direction, driverDesc,
> sizeof( driverDesc ) - 1, &descriptionLength, driverAttributes,
> sizeof( driverAttributes ), &attr_ret ) ) == SQL_SUCCESS )
>              {
>                  while( ( ret = SQLDataSources( m_henv, direct, dsn,
> SQL_MAX_DSN_LENGTH, &pcbDSN, dsnDescr, 254, &pcbDesc ) ) ==
> SQL_SUCCESS )
>                  {
>                      printf( "Driver description is %s", driverDesc );
>                      printf( "DSN description is %s", dsnDescr );
>                      direct = SQL_FETCH_NEXT;
>                  }
>                  if( ret != SQL_SUCCESS && ret != SQL_NO_DATA )
>                  {
>                      printf( "Error retrieving Data Source" );
>                      while( ( ret = SQLGetDiagRec( SQL_HANDLE_ENV,
> m_henv, i, sqlState, &nativeError, errMsg, sizeof( errMsg ),
> &cbErrorMsg ) ) == SQL_SUCCESS )
>                      {
>                          printf( "Error is: %s\r\n", errMsg );
>                      }
>                      break;
>                  }
>                  direction = SQL_FETCH_NEXT;
>              }
>          }
>      }
>      return 0;
> }
> [/code]
>
> resulted in:
>
> [code]
> igor@IgorDellGentoo ~ $ gcc -DUNICODE odbctest.cpp -o odbctest -lodbc
> odbctest.cpp: In function 'int main(int, char**)':
> odbctest.cpp:30:48: warning: format '%s' expects argument of type
> 'char*', but argument 2 has type 'SQLWCHAR* {aka short unsigned int*}'
> [-Wformat=]
>               printf( "Error is: %s\r\n", errMsg );
>                                                  ^
> odbctest.cpp:42:52: warning: format '%s' expects argument of type
> 'char*', but argument 2 has type 'SQLWCHAR* {aka short unsigned int*}'
> [-Wformat=]
>                   printf( "Error is: %s\r\n", errMsg );
>                                                      ^
> odbctest.cpp:52:68: warning: format '%s' expects argument of type
> 'char*', but argument 2 has type 'SQLWCHAR* {aka short unsigned int*}'
> [-Wformat=]
>                       printf( "Driver description is %s", driverDesc );
>                                                                      ^
> odbctest.cpp:53:63: warning: format '%s' expects argument of type
> 'char*', but argument 2 has type 'SQLWCHAR* {aka short unsigned int*}'
> [-Wformat=]
>                       printf( "DSN description is %s", dsnDescr );
>                                                                 ^
> odbctest.cpp:61:60: warning: format '%s' expects argument of type
> 'char*', but argument 2 has type 'SQLWCHAR* {aka short unsigned int*}'
> [-Wformat=]
>                           printf( "Error is: %s\r\n", errMsg );
>                                                              ^
> [/code]
>
> Any idea what is going on? And how to fix it?
>
> Thank you.

Err, I think the compiler is telling you, You have a array

SQLWCHAR errMsg[SQL_MAX_MESSAGE_LENGTH]

Which is actually

unsigned short errMsg[];

The you are passing this to a

printf( "%s", errMsg );

%s expects a char[] not a short[] so the error.

-- 
Nick
>
>> --
>> Nick
>> _______________________________________________
>> unixODBC-dev mailing list
>> [email protected]
>> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev
> _______________________________________________
> unixODBC-dev mailing list
> [email protected]
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev

_______________________________________________
unixODBC-dev mailing list
[email protected]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev