OTL 4.0, Examples for MS SQL, Unicode

The examples below show how to use OTL/ODBC with MS SQL and Unicode based strings (NVARCHAR, NCHAR, NTEXT). In  C++, all string data is represented as  2-byte Unicode characters.  In order to enable OTL/ODBC and Unicode, the following #defines need to be defined: #define OTL_ODBC, #define OTL_UNICODE.
  1. Example 271  (Simple Unicode Insert/Select and NVARCHAR strings)
  2. Example 272 (Simple Unicode Insert/Select with NTEXT)
  3. Example 273 (Simple Unicode Insert/Select with NTEXT, and LOB streams)
  4. Example 359 (Unicode NVARCHAR Insert/Select and #define OTL_UNICODE_CHAR_TYPE)
  5. Example 360 (Unicode NVARCHAR Insert/Select and #define OTL_UNICODE_STRING_TYPE)
  6. Example 365 (#define OTL_UNICODE_EXCEPTION_AND_RLOGON)
  7. Example 368 (NTEXT Insert/Select and #define OTL_UNICODE_STRING_TYPE)
  8. Example 499 (Simple Unicode Insert/Select with MS SQL 2005 NVARCHAR(MAX), and LOB streams)
  9. Example 669 (XML as varchar_long/otl_long_unicode_string on SELECT, and varchar_unicode_long/otl_long_string on INSERT)
  10. Example 670 (XML as varchar_long/wstring  on SELECT and varchar_long/wstring on INSERT)

Contents  Go Home

Copyright © 1996, 2008, Sergei Kuchin, email: skuchin@aceweb.com, skuchin@gmail.com .

Permission to use, copy, modify and redistribute this document for any purpose is hereby granted without fee, provided that the above copyright notice appear in all copies.