we have issue with following insert in the database
insert into ABC (ADDRESS_ID,
STREET_NAME, CITY, COUNTRY_CODE, ADDRESS_2, ADDRESS_3, IS_ACTIVE, CHANGE_WHO,
CHANGE_DT, FRANCHISE_TAX_CODE, FX_GEOCODE) values(14057,'კნოლევის ქ.','თბილისი',268,'თბილისი',268,1,'csmuser',to_date('18-11-2013 10:00:00',
'dd-mm-yyyy hh24:mi:ss'),2,840002000000000);
Here problem is, databae is not able to understand the Georgian character
we are able to insert but when selecting it shows as ??????,
UTS8 characteristics set for the database …
PARAMETER |
VALUE |
NLS_NCHAR_CHARACTERSET |
AL16UTF16 |
NLS_LANGUAGE |
AMERICAN |
NLS_TERRITORY |
AMERICA |
NLS_CURRENCY |
$ |
NLS_ISO_CURRENCY |
AMERICA |
NLS_NUMERIC_CHARACTERS |
., |
NLS_CHARACTERSET |
UTF8 |
NLS_CALENDAR |
GREGORIAN |
NLS_DATE_FORMAT |
YYYY-MM-DD
HH24:MI:SS |
NLS_DATE_LANGUAGE |
AMERICAN |
NLS_SORT |
BINARY |
NLS_TIME_FORMAT |
- HH.MI.SSXFF
AM
|
NLS_TIMESTAMP_FORMAT |
DD-MON-RR HH.MI.SSXFF
AM |
NLS_TIME_TZ_FORMAT |
- HH.MI.SSXFF AM
TZR
|
NLS_TIMESTAMP_TZ_FORMAT |
DD-MON-RR HH.MI.SSXFF AM
TZR |
NLS_DUAL_CURRENCY |
$ |
NLS_COMP |
BINARY |
NLS_LENGTH_SEMANTICS |
BYTE |
NLS_NCHAR_CONV_EXCP |
FALSE |
NLS_RDBMS_VERSION |
- 11.2.0.3.0
|
Any help greately appricited
Thanks