Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NLS_SORT for Turkish in uppercase

Saaz EnaMar 10 2011 — edited Mar 25 2011
Hi all,

I am using Oracle 10g
I have a string in Turkish and I want to upper case it in Turkish. When I use the below command I get it in uppercase but I want the i to be as I without the dot above I.
 
SQL> SELECT NLS_UPPER('Nasilsin?,  Ben Iyiyim', 'NLS_SORT = XTURKISH') FROM DUAL;
 
NLS_UPPER('NASILSIN?,BENIYIYIM
------------------------------
NASILSIN?,  BEN IYIYIM
 
SQL> SELECT NLS_UPPER('Nasilsin?,  Ben Iyiyim', 'NLS_SORT = TURKISH') FROM DUAL;
 
NLS_UPPER('NASILSIN?,BENIYIYI
------------------------------
NASILSIN?,  BEN IYIYIM
 
SQL> 
Here in the above image u can see I without the dot but in Oracle it has a dot.

Could someone put light on it.
Thanks in Advance
Rgds
Saaz
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 22 2011
Added on Mar 10 2011
6 comments
2,371 views