OTL 4.0, Examples for Oracle 9i, UTF8

The examples below show how to use OTL with Oracle 9i and UTF-8 based strings. At the database level,, the string format may vary (say, AL32UTF8 for the main character set and UTF-16 for the NLS), and at least at the C++ level all string data gets converted  into '\0' terminated byte arrays.  In order to enable OTL/OCI9I and UTF8, the following #defines need to be defined: #define OTL_ORA9I, #define OTL_ORA_UTF8.
  1. Example 481 (UTF8 Insert/Select)
  2. Example 482 (UTF8 NVARCHAR2 Insert/Select)
  3. Example 483 (UTF8 Insert and Select via referenced cursor)
  4. Example 484 (UTF8 Insert/Select with LONG)
  5. Example 485 (UTF8 Insert/Select with CLOB)
  6. Example 486 (UTF8 Insert/Select with NCLOB)
  7. Example 487 (UTF8 Insert/Select with CLOB via referenced cursor)
  8. Example 488 (UTF8 Insert/Select with NCLOB via referenced cursor)
  9. Example 489 (UTF8 Insert/Select with CLOB, and LOB streams)
  10. Example 490 (UTF8 Insert/Select with NCLOB, and LOB streams)
  11. Example 491 (UTF8, VARCHAR2, and otl_refcur_stream)
  12. Example 492 (UTF8, NVARCHAR2, and otl_refcur_stream)
  13. Example 493 (UTF8, PLSQL/index-by tables as parameters)
  14. Example 494 (UTF8, PLSQL/index-by tables as parameters, and NVARCHAR2s)
  15. Example 495 (UTF8 Insert/Select for both VARCHAR2 and NVARCHAR2 at the same time)
  16. Example 496 (UTF8 Insert/Select for both CLOB  and NCLOB  at the same time)
  17. Example 663 (Oracle 9i, XMLType as CLOB/otl_long_string on SELECT, and char[XXX] on INSERT)
  18. Example 664 (Oracle 9i, XMLType as CLOB/otl_long_string on SELECT, and varchar_long/otl_long_string on INSERT)

Prev NextContentsGo 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.