This discussion is archived
3 Replies Latest reply: Oct 30, 2012 11:38 PM by kgronau RSS

UTF8 characters issue

user415250 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points