ODBC eway loses Danish characters (Doc ID 1027262.1)

Last updated on SEPTEMBER 13, 2004

Applies to:

Sun SeeBeyond e*Gate - Version: 4.5.1 and later
IBM AIX on POWER Systems (32-bit)

Symptoms

ODBC eway loses Danish characters

Additional Information :

The following error appeared when trying to insert a Danish string into a Microsoft SQL Server table using the Monk ODBC e*Way. The following insert statement was being used:

(db-sql-execute hdbc "insert into mytown(cityname) values ('Byhøj-Knudsen')")

Diagnostics:

01:53:35.638 MNK I 258 (monklog:406): db-sql-execute: ODBC|37000|105|MERANT|ODBC SQL Server Driver|SQL Server|Unclosed quotation mark before the character string 'Byh'.
ODBC|37000|170|MERANT|ODBC SQL Server Driver|SQL Server|Line 1: Incorrect syntax near 'Byh'.
DART|62|DGDB_X_conn_sql_exec_len||unable to execute SQL statement
01:53:37.925 MNK I 258 (monklog:391): ODBC|37000|105|MERANT|ODBC SQL Server Driver|SQL Server|Unclosed quotation mark
01:53:37.925 MNK I 258 (monklog:406): before the character string 'Byh'.
ODBC|37000|170|MERANT|ODBC SQL Server Driver|SQL Server|Line 1: Incorrect synta
01:53:37.925 MNK I 258 (monklog:406): x near 'Byh'.
DART|62|DGDB_X_conn_sql_exec_len||unable to execute SQL statement

ie The insert statement was incorrectly treating the first extended character (the oslash ø character) in the string as the string terminator.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms