3 Replies Latest reply: Oct 31, 2012 1:38 AM by Kgronau-Oracle RSS

    UTF8 characters issue

    user415250
      When selecting nvarchar field values from SQLServer server into Oracle nvarchar2 variables over an Oracle dg4odbc or dg4msql dblink, Chinese and other multi-byte characters appear as inverted question marks; however, the same select statement in SQLDeveloper displays all characters correctly. Please advise


      System #1
      Oracle database version is 11.2.0.1
      Oracle database server is Windows 2008 R2
      DG4ODBC driver version is 11.2.0.1.0

      System #2
      Oracle database version is 11.2.0.3
      Oracle database server is Linux Redhat 6
      DG4MSQL driver is 11.2.0.3.0

      Oracle NLS parameters - both instances:
      NLS_CALENDAR     GREGORIAN
      NLS_CHARACTERSET     WE8MSWIN1252
      NLS_COMP     BINARY
      NLS_CURRENCY     $
      NLS_DATE_FORMAT     DD-MON-RR HH:MI:SS AM
      NLS_DATE_LANGUAGE     AMERICAN
      NLS_DUAL_CURRENCY     $
      NLS_ISO_CURRENCY     AMERICA
      NLS_LANGUAGE     AMERICAN
      NLS_LENGTH_SEMANTICS     BYTE
      NLS_NCHAR_CHARACTERSET     AL16UTF16
      NLS_NCHAR_CONV_EXCP     FALSE
      NLS_NUMERIC_CHARACTERS     .,
      NLS_SORT     BINARY
      NLS_TERRITORY     AMERICA
      NLS_TIMESTAMP_FORMAT     DD-MON-RR HH.MI.SSXFF AM
      NLS_TIMESTAMP_TZ_FORMAT     DD-MON-RR HH.MI.SSXFF AM TZR
      NLS_TIME_FORMAT     HH.MI.SSXFF AM
      NLS_TIME_TZ_FORMAT     HH.MI.SSXFF AM TZR

      Oracle hs init parameters:
      See trace file below

      Test Procedure:
      create or replace
      procedure test_pdd as
      my_part_id varchar2(32);
      my_product_name nvarchar2(2000);

      begin
      select "PartID#", "Product Name" into my_part_id, my_product_name
      from "dbo"."PSM_A_VIEW"@"PRODUCTTRACKING.STEMCELL.COM" WHERE "PartID#" = 'Example_PSM';
      dbms_output.put_line(my_product_name);
      end test_pdd;

      Output:
      Connecting to the database stemcell - 11g-prod-coeadm.
      ¿¿¿¿¿¿¿¿¿¿¿Greek: a, ß ¿/d
      Process exited.
      Disconnecting from the database stemcell - 11g-prod-coeadm.


      Trace file Output:

      Oracle Corporation --- MONDAY OCT 29 2012 08:08:26.982


      Heterogeneous Agent Release
      11.2.0.3.0




      Oracle Corporation --- MONDAY OCT 29 2012 08:08:26.981

      Version 11.2.0.3.0

      Entered hgogprd
      HOSGIP for "HS_FDS_TRACE_LEVEL" returned "DEBUG"
      Entered hgosdip
      setting HS_OPEN_CURSORS to default of 50
      setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"
      setting HS_FDS_RECOVERY_PWD to default value
      setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG
      setting HS_IDLE_TIMEOUT to default of 0
      setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
      setting HS_NLS_NCHAR to default of "AL32UTF8"
      setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"
      setting HS_FDS_DATE_MAPPING to default of "DATE"
      setting HS_RPC_FETCH_REBLOCKING to default of "ON"
      setting HS_FDS_FETCH_ROWS to default of "100"
      setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
      setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE"
      setting HS_FDS_PROC_IS_FUNC to default of "FALSE"
      setting HS_FDS_MAP_NCHAR to default of "TRUE"
      setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"
      setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"
      setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"
      setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"
      setting HS_FDS_QUERY_DRIVER to default of "FALSE"
      setting HS_FDS_SUPPORT_STATISTICS to default of "TRUE"
      setting HS_FDS_QUOTE_IDENTIFIER to default of "TRUE"
      setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"
      setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"
      setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"
      setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"
      setting HS_FDS_DELAYED_OPEN to default of "TRUE"
      setting HS_FDS_WORKAROUNDS to default of "0"
      Exiting hgosdip, rc=0
      ORACLE_SID is "PRODUCTTRACKING"
      Product-Info:
      Port Rls/Upd:3/0 PrdStat:0
      Agent:Oracle Database Gateway for MSSQL
      Facility:hsa
      Class:MSSQL, ClassVsn:11.2.0.3.0_0011, Instance:PRODUCTTRACKING
      Exiting hgogprd, rc=0
      Entered hgoinit
      HOCXU_COMP_CSET=1
      HOCXU_DRV_CSET=873
      HOCXU_DRV_NCHAR=873
      HOCXU_DB_CSET=178
      HS_LANGUAGE is AL32UTF8
      LANG=en_US.UTF-8
      HOCXU_SEM_VER=112000
      HOSGIP for "HS_FDS_REMOTE_DB_CHARSET" returned "WE8MSWIN1252"
      Entered hgolofn at 2012/10/29-08:08:26
      ODBCINST set to "/usr/local/oracle/product/11.2.0/db/dg4msql/driver/dg4msql.loc"
      RC=-1 from HOSGIP for "LD_LIBRARY_PATH"
      LD_LIBRARY_PATH from environment is "/usr/local/oracle/product/11.2.0/db/dg4msql/driver/lib:/usr/local/oracle/product/11.2.0/db/lib"
      Setting LD_LIBRARY_PATH to "/usr/local/oracle/product/11.2.0/db/dg4msql/driver/lib:/usr/local/oracle/product/11.2.0/db/dg4msql/driver/lib:/usr/local/oracle/product/11.2.0/db/lib"
      HOSGIP for "HS_FDS_SHAREABLE_NAME_ICU" returned "/usr/local/oracle/product/11.2.0/db/dg4msql/driver/lib/libHGicu23.so"
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2da59b74
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      HOSGIP for "HS_FDS_SHAREABLE_NAME_INST" returned "/usr/local/oracle/product/11.2.0/db/dg4msql/driver/lib/libodbcinst.so"
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d85065e
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/usr/local/oracle/product/11.2.0/db/dg4msql/driver/lib/libodbc.so"
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5d5ac0
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5d61a0
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5d633c
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5d6be6
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5d8fac
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5d9148
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5d9612
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5d9fa8
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5da258
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5dada4
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5db834
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5dd1c8
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5de2ba
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5de446
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5dee82
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5df432
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5df57a
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5e0674
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5e07dc
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5e24c4
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5e2290
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5d6e8a
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5d7a34
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5d7e84
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5d8b6e
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5d926a
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5d9ce2
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5da4e2
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5dbe04
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5dd366
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5dd6ae
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5ddb7a
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5ddeea
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5de5ae
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5de8ce
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5debe6
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5df828
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5dfaf4
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5dfe8c
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5e02dc
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5e0924
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5e2b38
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5e1f70
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5e32d4
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Entered hgolofns at 2012/10/29-08:08:26
      symbol_peflctx=0x2d5e3ad8
      hoaerr:0
      Exiting hgolofns at 2012/10/29-08:08:26
      Exiting hgolofn, rc=0 at 2012/10/29-08:08:26
      HOSGIP for "HS_OPEN_CURSORS" returned "50"
      HOSGIP for "HS_FDS_FETCH_ROWS" returned "100"
      HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
      HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"
      HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"
      HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE"
      HOSGIP for "HS_FDS_WORKAROUNDS" returned "0"
      HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"
      HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"
      treat_SQLLEN_as_compiled = 1
      Exiting hgoinit, rc=0 at 2012/10/29-08:08:26
      Entered hgolgon at 2012/10/29-08:08:26
      reco:0, name:Website_Int, tflag:0
      Entered hgosuec at 2012/10/29-08:08:26
      uencoding=UTF8
      Entered shgosuec at 2012/10/29-08:08:26
      Exiting shgosuec, rc=0 at 2012/10/29-08:08:26
      shgosuec() returned rc=0
      Exiting hgosuec, rc=0 at 2012/10/29-08:08:26
      HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
      HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"
      HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"
      HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE"
      HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
      HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"
      HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"
      HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
      HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
      using Website_Int as default value for "HS_FDS_DEFAULT_OWNER"
      HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
      Entered hgocont at 2012/10/29-08:08:26
      HS_FDS_CONNECT_INFO = "sti-sql01:1433//PRODUCTTRACKING"
      RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
      Entered hgogenconstr at 2012/10/29-08:08:26
      dsn:sti-sql01:1433//PRODUCTTRACKING, name:Website_Int
      optn:
      Entered hgocip at 2012/10/29-08:08:26
      dsn:sti-sql01:1433//PRODUCTTRACKING
      Exiting hgocip, rc=0 at 2012/10/29-08:08:26
      Entered shgogohn at 2012/10/29-08:08:26
      Exiting shgogohn, rc=28500 at 2012/10/29-08:08:26
      Exiting hgogenconstr, rc=0 at 2012/10/29-08:08:26
      Entered hgopoer at 2012/10/29-08:08:32
      hgopoer, line 231: got native error 5701 and sqlstate 01000; message follows...
      [Oracle][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Changed database context to 'PRODUCTTRACKING'. {01000,NativeErr = 5701}[Oracle][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Changed language setting to us_english. {01000,NativeErr = 5703}
      Exiting hgopoer, rc=0 at 2012/10/29-08:08:32
      hgocont, line 2687: calling SqlDriverConnect got sqlstate 01000
      Entered hgolosf at 2012/10/29-08:08:32
      Exiting hgolosf, rc=0 at 2012/10/29-08:08:32
      DriverName:HGsqls23.so, DriverVer:06.10.0075 (B0060, U0031)
      DBMS Name:Microsoft SQL Server, DBMS Version:10.50.2500
      Exiting hgocont, rc=0 at 2012/10/29-08:08:32 with error ptr FILE:hgocont.c LINE:2687 FUNCTION:hgocont() ID:SQLDriverConnect
      SQLGetInfo returns Y for SQL_CATALOG_NAME
      SQLGetInfo returns 128 for SQL_MAX_CATALOG_NAME_LEN
      Exiting hgolgon, rc=0 at 2012/10/29-08:08:32
      Entered hgoulcp at 2012/10/29-08:08:32
      Entered hgowlst at 2012/10/29-08:08:32
      Exiting hgowlst, rc=1 at 2012/10/29-08:08:32
      SQLGetInfo returns Y for SQL_PROCEDURES
      SQLGetInfo returns 0x1f for SQL_OWNER_USAGE
      TXN Capable:2, Isolation Option:0xf
      SQLGetInfo returns 128 for SQL_MAX_SCHEMA_NAME_LEN
      SQLGetInfo returns 128 for SQL_MAX_TABLE_NAME_LEN
      SQLGetInfo returns 134 for SQL_MAX_PROCEDURE_NAME_LEN
      HOSGIP returned value of "TRUE" for HS_FDS_QUOTE_IDENTIFIER
      SQLGetInfo returns " (0x22) for SQL_IDENTIFIER_QUOTE_CHAR
      1 instance capability will be uploaded
      capno:1992, context:0x0001ffff, add-info: 0
      Exiting hgoulcp, rc=0 at 2012/10/29-08:08:32
      Entered hgouldt at 2012/10/29-08:08:32
      NO instance DD translations were uploaded
      Exiting hgouldt, rc=0 at 2012/10/29-08:08:32
      Entered hgobegn at 2012/10/29-08:08:32
      tflag:0 , initial:1
      hoi:0x3f23db58, ttid (len 40) is ...
      00: 5354454D 43454C4C 2E535445 4D43454C [STEMCELL.STEMCEL]
      10: 4C2E434F 4D2E3164 65366530 39362E32 [L.COM.1de6e096.2]
      20: 312E362E 31353530 [1.6.1550]
      tbid (len 38) is ...
      00: 5354454D 43454C4C 2E535445 4D43454C [STEMCELL.STEMCEL]
      10: 4C2E434F 4D5B3231 2E362E31 3535305D [L.COM[21.6.1550]]
      20: 5B312E31 305D [[1.10]]
      Exiting hgobegn, rc=0 at 2012/10/29-08:08:32
      Entered hgodtab at 2012/10/29-08:08:32
      count:1
      table: dbo.PSM_A_VIEW
      Allocate hoada[0] @ 0xdb1020
      Entered hgopcda at 2012/10/29-08:08:32
      Column:1(PartID#): dtype:-9 (WVARCHAR), prc/scl:16/0, nullbl:0, octet:16, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2012/10/29-08:08:32
      Entered hgopcda at 2012/10/29-08:08:32
      Column:2(Product Name): dtype:-9 (WVARCHAR), prc/scl:120/0, nullbl:1, octet:120, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2012/10/29-08:08:32
      Entered hgopcda at 2012/10/29-08:08:32
      Column:3(Description_C): dtype:-9 (WVARCHAR), prc/scl:2000/0, nullbl:1, octet:2000, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2012/10/29-08:08:32
      Entered hgopcda at 2012/10/29-08:08:32
      Column:4(ShortDescription_C): dtype:-9 (WVARCHAR), prc/scl:2000/0, nullbl:1, octet:2000, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2012/10/29-08:08:32
      Entered hgopcda at 2012/10/29-08:08:32
      Column:5(IntendedUseStatement): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:1792, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2012/10/29-08:08:32
      Entered hgopcda at 2012/10/29-08:08:32
      Column:6(RelatedProducts_C): dtype:-9 (WVARCHAR), prc/scl:2000/0, nullbl:1, octet:2000, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2012/10/29-08:08:32
      Entered hgopcda at 2012/10/29-08:08:32
      Column:7(RecommendedFor_C): dtype:-9 (WVARCHAR), prc/scl:2000/0, nullbl:1, octet:2000, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2012/10/29-08:08:32
      Entered hgopcda at 2012/10/29-08:08:32
      Column:8(AccessoryProducts_C): dtype:-9 (WVARCHAR), prc/scl:2000/0, nullbl:1, octet:2000, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2012/10/29-08:08:32
      Entered hgopcda at 2012/10/29-08:08:32
      Column:9(Components_C): dtype:-9 (WVARCHAR), prc/scl:2000/0, nullbl:1, octet:2000, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2012/10/29-08:08:32
      Entered hgopcda at 2012/10/29-08:08:32
      Column:10(FormulationToCustomer_C): dtype:-9 (WVARCHAR), prc/scl:2000/0, nullbl:1, octet:2000, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2012/10/29-08:08:32
      Entered hgopcda at 2012/10/29-08:08:32
      Column:11(EquipmentRequired_C): dtype:-9 (WVARCHAR), prc/scl:2000/0, nullbl:1, octet:2000, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2012/10/29-08:08:32
      Entered hgopcda at 2012/10/29-08:08:32
      Column:12(HazardInfo_C): dtype:-9 (WVARCHAR), prc/scl:2000/0, nullbl:1, octet:2000, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2012/10/29-08:08:32
      Entered hgopcda at 2012/10/29-08:08:32
      Column:13(LegalStatement_C): dtype:-9 (WVARCHAR), prc/scl:2000/0, nullbl:1, octet:2000, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2012/10/29-08:08:32
      Entered hgopcda at 2012/10/29-08:08:32
      Column:14(Advantages_C): dtype:-9 (WVARCHAR), prc/scl:2000/0, nullbl:1, octet:2000, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2012/10/29-08:08:32
      Entered hgopcda at 2012/10/29-08:08:32
      Column:15(BackgroundReferences_C): dtype:-9 (WVARCHAR), prc/scl:2000/0, nullbl:1, octet:2000, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2012/10/29-08:08:32
      Entered hgopcda at 2012/10/29-08:08:32
      Column:16(ProductReferences_C): dtype:-9 (WVARCHAR), prc/scl:2000/0, nullbl:1, octet:2000, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2012/10/29-08:08:32
      Entered hgopcda at 2012/10/29-08:08:32
      Column:17(MKT PSM Status): dtype:-9 (WVARCHAR), prc/scl:10/0, nullbl:1, octet:10, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2012/10/29-08:08:32
      The hoada for table dbo.PSM_A_VIEW follows...
      hgodtab, line 1092: Printing hoada @ 0xdb1020
      MAX:17, ACTUAL:17, BRC:1, WHT=6 (TABLE_DESCRIBE)
      hoadaMOD bit-values found (0x40:TREAT_AS_NCHAR,0x400:UNICODE_COLUMN)
      DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
      12 VARCHAR N 16 16 128/ 16 873 0 440 PartID#
      12 VARCHAR Y 120 120 128/120 873 0 440 Product Name
      12 VARCHAR Y 2000 2000 135/208 873 0 440 Description_C
      12 VARCHAR Y 2000 2000 135/208 873 0 440 ShortDescription_C
      4 INTEGER Y 4 4 0/ 0 0 0 0 IntendedUseStatement
      12 VARCHAR Y 2000 2000 135/208 873 0 440 RelatedProducts_C
      12 VARCHAR Y 2000 2000 135/208 873 0 440 RecommendedFor_C
      12 VARCHAR Y 2000 2000 135/208 873 0 440 AccessoryProducts_C
      12 VARCHAR Y 2000 2000 135/208 873 0 440 Components_C
      12 VARCHAR Y 2000 2000 135/208 873 0 440 FormulationToCustomer_C
      12 VARCHAR Y 2000 2000 135/208 873 0 440 EquipmentRequired_C
      12 VARCHAR Y 2000 2000 135/208 873 0 440 HazardInfo_C
      12 VARCHAR Y 2000 2000 135/208 873 0 440 LegalStatement_C
      12 VARCHAR Y 2000 2000 135/208 873 0 440 Advantages_C
      12 VARCHAR Y 2000 2000 135/208 873 0 440 BackgroundReferences_C
      12 VARCHAR Y 2000 2000 135/208 873 0 440 ProductReferences_C
      12 VARCHAR Y 10 10 128/ 10 873 0 440 MKT PSM Status
      Exiting hgodtab, rc=0 at 2012/10/29-08:08:32
      Entered hgodafr, cursor id 0 at 2012/10/29-08:08:32
      Free hoada @ 0xdb1020
      Exiting hgodafr, rc=0 at 2012/10/29-08:08:32
      Entered hgotcis at 2012/10/29-08:08:32
      Calling SQLStatistics for dbo.PSM_A_VIEW
      Calling SQLColumns for dbo.PSM_A_VIEW
      Column "PartID#": dtype=-9, colsize=16, decdig=0, char_octet_length=16, cumulative avg row len=12
      Column "Product Name": dtype=-9, colsize=120, decdig=0, char_octet_length=120, cumulative avg row len=102
      Column "Description_C": dtype=-9, colsize=2000, decdig=0, char_octet_length=2000, cumulative avg row len=1602
      Column "ShortDescription_C": dtype=-9, colsize=2000, decdig=0, char_octet_length=2000, cumulative avg row len=3102
      Column "IntendedUseStatement": dtype=4, colsize=10, decdig=0, char_octet_length=1792, cumulative avg row len=3106
      Column "RelatedProducts_C": dtype=-9, colsize=2000, decdig=0, char_octet_length=2000, cumulative avg row len=4606
      Column "RecommendedFor_C": dtype=-9, colsize=2000, decdig=0, char_octet_length=2000, cumulative avg row len=6106
      Column "AccessoryProducts_C": dtype=-9, colsize=2000, decdig=0, char_octet_length=2000, cumulative avg row len=7606
      Column "Components_C": dtype=-9, colsize=2000, decdig=0, char_octet_length=2000, cumulative avg row len=9106
      Column "FormulationToCustomer_C": dtype=-9, colsize=2000, decdig=0, char_octet_length=2000, cumulative avg row len=10606
      Column "EquipmentRequired_C": dtype=-9, colsize=2000, decdig=0, char_octet_length=2000, cumulative avg row len=12106
      Column "HazardInfo_C": dtype=-9, colsize=2000, decdig=0, char_octet_length=2000, cumulative avg row len=13606
      Column "LegalStatement_C": dtype=-9, colsize=2000, decdig=0, char_octet_length=2000, cumulative avg row len=15106
      Column "Advantages_C": dtype=-9, colsize=2000, decdig=0, char_octet_length=2000, cumulative avg row len=16606
      Column "BackgroundReferences_C": dtype=-9, colsize=2000, decdig=0, char_octet_length=2000, cumulative avg row len=18106
      Column "ProductReferences_C": dtype=-9, colsize=2000, decdig=0, char_octet_length=2000, cumulative avg row len=19606
      Column "MKT PSM Status": dtype=-9, colsize=10, decdig=0, char_octet_length=10, cumulative avg row len=19613
      Exiting hgotcis, rc=0 at 2012/10/29-08:08:32
      Entered hgopars, cursor id 1 at 2012/10/29-08:08:32
      type:0
      SQL text from hgopars, id=1, len=97 ...
      00: 53454C45 43542041 312E2250 61727449 [SELECT A1."PartI]
      10: 4423222C 41312E22 50726F64 75637420 [D#",A1."Product ]
      20: 4E616D65 22204652 4F4D2022 64626F22 [Name" FROM "dbo"]
      30: 2E225053 4D5F415F 56494557 22204131 [."PSM_A_VIEW" A1]
      40: 20574845 52452041 312E2250 61727449 [ WHERE A1."PartI]
      50: 4423223D 27457861 6D706C65 5F50534D [D#"='Example_PSM]
      60: 27 [']
      Exiting hgopars, rc=0 at 2012/10/29-08:08:32
      Entered hgoopen, cursor id 1 at 2012/10/29-08:08:32
      hgoopen, line 87: NO hoada to print
      Deferred open until first fetch.
      Exiting hgoopen, rc=0 at 2012/10/29-08:08:32
      Entered hgodscr, cursor id 1 at 2012/10/29-08:08:32
      Allocate hoada @ 0xdb1000
      Entered hgodscr_process_sellist_description at 2012/10/29-08:08:32
      Entered hgopcda at 2012/10/29-08:08:32
      Column:1(PartID#): dtype:-9 (WVARCHAR), prc/scl:16/0, nullbl:0, octet:48, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2012/10/29-08:08:32
      Entered hgopcda at 2012/10/29-08:08:32
      Column:2(Product Name): dtype:-9 (WVARCHAR), prc/scl:120/0, nullbl:1, octet:360, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2012/10/29-08:08:32
      hgodscr, line 464: Printing hoada @ 0xdb1000
      MAX:2, ACTUAL:2, BRC:100, WHT=5 (SELECT_LIST)
      hoadaMOD bit-values found (0x40:TREAT_AS_NCHAR,0x400:UNICODE_COLUMN)
      DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
      12 VARCHAR N 48 48 128/ 16 873 0 440 PartID#
      12 VARCHAR Y 360 360 128/120 873 0 440 Product Name
      Exiting hgodscr, rc=0 at 2012/10/29-08:08:32
      Entered hgoftch, cursor id 1 at 2012/10/29-08:08:32
      hgoftch, line 133: Printing hoada @ 0xdb1000
      MAX:2, ACTUAL:2, BRC:100, WHT=5 (SELECT_LIST)
      hoadaMOD bit-values found (0x40:TREAT_AS_NCHAR,0x400:UNICODE_COLUMN)
      DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
      12 VARCHAR N 48 48 128/ 16 873 0 440 PartID#
      12 VARCHAR Y 360 360 128/120 873 0 440 Product Name
      Performing delayed open.
      SQLBindCol: column 1, cdatatype: -8, bflsz: 49
      SQLBindCol: column 2, cdatatype: -8, bflsz: 361
      SQLFetch: row: 1, column 1, bflsz: 49, bflar: 11
      SQLFetch: row: 1, column 1, bflsz: 49, bflar: 11, (bfl: 48, mbl: 48)
      SQLFetch: row: 1, column 2, bflsz: 361, bflar: 53
      SQLFetch: row: 1, column 2, bflsz: 361, bflar: 53, (bfl: 360, mbl: 360)
      1 rows fetched
      Exiting hgoftch, rc=0 at 2012/10/29-08:08:32
      Entered hgoftch, cursor id 1 at 2012/10/29-08:08:32
      hgoftch, line 133: Printing hoada @ 0xdb1000
      MAX:2, ACTUAL:2, BRC:1, WHT=5 (SELECT_LIST)
      hoadaMOD bit-values found (0x40:TREAT_AS_NCHAR,0x400:UNICODE_COLUMN)
      DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
      12 VARCHAR N 11 48 128/ 16 873 0 440 PartID#
      12 VARCHAR Y 53 360 128/120 873 0 440 Product Name
      0 rows fetched
      Exiting hgoftch, rc=1403 at 2012/10/29-08:08:32
      Entered hgoclse, cursor id 1 at 2012/10/29-08:08:32
      Exiting hgoclse, rc=0 at 2012/10/29-08:08:32
      Entered hgodafr, cursor id 1 at 2012/10/29-08:08:32
      Free hoada @ 0xdb1000
      Exiting hgodafr, rc=0 at 2012/10/29-08:08:32
      Entered hgocomm at 2012/10/29-08:08:32
      keepinfo:0, tflag:1
      00: 5354454D 43454C4C 2E535445 4D43454C [STEMCELL.STEMCEL]
      10: 4C2E434F 4D2E3164 65366530 39362E32 [L.COM.1de6e096.2]
      20: 312E362E 31353530 [1.6.1550]
      tbid (len 38) is ...
      00: 5354454D 43454C4C 2E535445 4D43454C [STEMCELL.STEMCEL]
      10: 4C2E434F 4D5B3231 2E362E31 3535305D [L.COM[21.6.1550]]
      20: 5B312E31 305D [[1.10]]
      cmt(0):
      Entered hgocpctx at 2012/10/29-08:08:32
      Exiting hgocpctx, rc=0 at 2012/10/29-08:08:32
      Exiting hgocomm, rc=0 at 2012/10/29-08:08:32
      Entered hgolgof at 2012/10/29-08:08:32
      tflag:1
      Exiting hgolgof, rc=0 at 2012/10/29-08:08:32
      Entered hgoexit at 2012/10/29-08:08:32
      Exiting hgoexit, rc=0
        • 1. Re: UTF8 characters issue
          Kgronau-Oracle
          It looks like you're hitting a defect #14725210 (PL/SQL ONLY :STRINGS ARE RETURNED WITH UNEXPECTED NULL VALUES FROM DG4MSQL) which is currently being worked on where a similar issue has already been reported.
          There's no fix yet available. You could check out the issue on My Oracle Support and track the progress on this issue or you can also file a service request to get a confirmation that you exactly hit this issue and get alerted as soon as the issue is fixed.
          • 2. Re: UTF8 characters issue
            user415250
            Thanks, I have looked defect report 14725212 and opened an SR with Oracle Support, however, I am also seeing this on a Windows 2008 R2 server using the dg4ODBC driver version 11.2.0.1. Would you know if this bug affects the dbgODBC driver too?
            • 3. Re: UTF8 characters issue
              Kgronau-Oracle
              For DG4ODBC there's another similar issue reported:
              BUG 13950747 - NCHAR/NVARCHAR USING DG4MSQL ADDS A SPACE/BLANK TO EVERY CHARACTER USING PL/SQL
              It was mentioned somewhere in the bug that it happens also with varchar in a Unicode env.