This discussion is archived
8 Replies Latest reply: Oct 16, 2012 5:29 AM by Osama_Mustafa RSS

Non-English character problem in Oracle 10g Express Edition

966347 Newbie
Currently Being Moderated
Hi There;
I have a table. It's name is INSTITUTION. It has a NUMBER INS_ID and NVARCHAR2(50) INS_NAME . INS_NAME can contain Turkish characters, such as "ğ,ü,ş,ç,ö". According to business logic, there can not be a repetition on the INS_NAME.
User will enter institution name from a textbox in ASP.NET , and I check this name in database from c sharp code, if there is no repetition, we will add this record.
**
The problem is; when user enter a instition name that contains Turkish character, there is a duplication. If there is a instition name is *"su işleri"* , the both query; SELECT * FROM INSTITUTION WHERE INS_NAME = *'su işleri'*; and SELECT * FROM INSTITUTION WHERE INS_NAME = *'su isleri'*; returns no result, even though there it is.
But if instition name is "oracle corporation" (there is no Turkish character) it query successfully. I have the same problem in Toad for Oracle 11.5.1.2. When I query database from toad SELECT * FROM INSTITUTION, the phrase *"su işleri"* has appeared. But when I query SELECT * FROM INSTITUTION WHERE INS_NAME = *'su işleri'*; , there is again no result.
When I connect oracle database directly and perform the query SELECT * FROM INSTITUTION , the phrase *"su isleri"* (not *"su işleri"* ) has appeared.

***
Here are the language settings of the database:

National Language Support
National Language Parameter Value
NLS_CALENDAR______________GREGORIAN
NLS_CHARACTERSET__________WE8MSWIN1252
NLS_COMP__________________BINARY
NLS_CURRENCY______________TL
NLS_DATE_FORMAT__________DD/MM/RRRR
NLS_DATE_LANGUAGE________TURKISH
NLS_DUAL_CURRENCY_________YTL
NLS_ISO_CURRENCY__________TURKEY
NLS_LANGUAGE______________TURKISH
NLS_LENGTH_SEMANTICS______BYTE
NLS_NCHAR_CHARACTERSET___AL16UTF16
NLS_NCHAR_CONV_EXCP______FALSE
NLS_NUMERIC_CHARACTERS____ ,.
NLS_SORT___________________TURKISH
NLS_TERRITORY______________TURKEY
NLS_TIME_FORMAT____________HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT_______DD/MM/RRRR HH24:MI:SSXFF
NLS_TIMESTAMP_TZ_FORMAT____DD/MM/RRRR HH24:MI:SSXFF TZR
NLS_TIME_TZ_FORMAT__________HH24:MI:SSXFF TZR


How can I resolve that problem? Thanks in advance.

Edited by: 963344 on 05.Eki.2012 01:00

Edited by: 963344 on 05.Eki.2012 01:01

Edited by: 963344 on 05.Eki.2012 01:06

Legend

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