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