National characters in insert statements
Posted: Thu 28 May 2015 13:29
I have problems with national characters in insert/update statements.
Inserting or updating fields with "handwritten" statements fails or changes national characters to a upside-down question marks. When entering national characters through dataaware controls it works.
My Delphi 2010 app is using Clientdatasets connecting to a datasnap middletier service. The middletier is using Devart Oracle Dbexpress driver.
What is causing this behavoiur ?
My database, instance and session parameters are
NLS_CALENDAR GREGORIAN GREGORIAN
NLS_CHARACTERSET WE8MSWIN1252
NLS_COMP BINARY BINARY BINARY
NLS_CURRENCY $ kr
NLS_DATE_FORMAT DD-MON-RR RR-MM-DD
NLS_DATE_LANGUAGE AMERICAN DANISH
NLS_DUAL_CURRENCY $ €
NLS_ISO_CURRENCY AMERICA DENMARK
NLS_LANGUAGE AMERICAN DANISH DANISH
NLS_LENGTH_SEMANTICS BYTE BYTE BYTE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_NCHAR_CONV_EXCP FALSE FALSE FALSE
NLS_NUMERIC_CHARACTERS ., ,.
NLS_RDBMS_VERSION 11.2.0.1.0
NLS_SORT BINARY DANISH
NLS_TERRITORY AMERICA DENMARK DENMARK
NLS_TIME_FORMAT HH.MI.SSXFF AM HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM RR-MM-DD HH24:MI:SSXFF
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR RR-MM-DD HH24:MI:SSXFF TZR
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR HH24:MI:SSXFF TZR
Inserting or updating fields with "handwritten" statements fails or changes national characters to a upside-down question marks. When entering national characters through dataaware controls it works.
My Delphi 2010 app is using Clientdatasets connecting to a datasnap middletier service. The middletier is using Devart Oracle Dbexpress driver.
What is causing this behavoiur ?
My database, instance and session parameters are
NLS_CALENDAR GREGORIAN GREGORIAN
NLS_CHARACTERSET WE8MSWIN1252
NLS_COMP BINARY BINARY BINARY
NLS_CURRENCY $ kr
NLS_DATE_FORMAT DD-MON-RR RR-MM-DD
NLS_DATE_LANGUAGE AMERICAN DANISH
NLS_DUAL_CURRENCY $ €
NLS_ISO_CURRENCY AMERICA DENMARK
NLS_LANGUAGE AMERICAN DANISH DANISH
NLS_LENGTH_SEMANTICS BYTE BYTE BYTE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_NCHAR_CONV_EXCP FALSE FALSE FALSE
NLS_NUMERIC_CHARACTERS ., ,.
NLS_RDBMS_VERSION 11.2.0.1.0
NLS_SORT BINARY DANISH
NLS_TERRITORY AMERICA DENMARK DENMARK
NLS_TIME_FORMAT HH.MI.SSXFF AM HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM RR-MM-DD HH24:MI:SSXFF
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR RR-MM-DD HH24:MI:SSXFF TZR
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR HH24:MI:SSXFF TZR