user771035 wrote:The g with breve, dotless i, and s with cedilla characters are typical Turkish letters, if I got that right? (The remaining characters can be found in 8859-1)
I want to store some turkish characters, for example ğçıöşü, and Its stored as ¿ç¿ö¿ü.
While in sqlplus, I am not able to copy the above turkish exactly and thus it gets pasted as .g.v.|.Please describe the procedure. (in sqlplus "gui" version on Windows, or are you using a terminal program like putty, how do you copy, etc. etc.)
Typ=96 Len=6 CharacterSet=WE8ISO8859P1: 2e,67,2e,76,2e,7cFrom this I would suspect that a replacement took place earlier on; the dot character code (0x2e) could indicate a font related problem when you copy-paste the string.
My issue gets reolved in Solaris box, with 11G database setting and charset set to WE8MSWIN1252.All the details provided above.If you copy paste as above to this 11g database, does it then work as expected (no dots)? If so, what are the differences between the two environments?
user771035 wrote:Well, since [windows-1252|http://www.microsoft.com/globaldev/reference/sbcs/1252.mspx] does not define Ğ, İ, Ş, ... , something is bound to be lost. But replacement rules tries to help out by providing a close match, i.e. G, S, and I.
I am now able to get , ĞÇIÖŞÜ as GÇIÖSÜ. However, The G and S should be like Ğ and Ş.
Is it because, my database characterset, still cannot support ALL turkish characters ? Which Database character set support ALL Turkish characters ?Yes!