UNICODE, special characters problem, multilingual support
434007Dec 3 2004 — edited Jul 29 2005 Problem is, we do not want whole oracle database in unicode but we want to use unicode for some columns. So we have AL16UTF16 as a national character set(we tried UTF8/AL32UTF8 too). We wanted to use NVARCHAR2 datatype for storing unicode data. but whenever we try to entere some unicode data it is storring only czech language but we would like to store arabic, russia and other special characters. if we create whole unicode database everything is ok, entering, reading and everything, but when we do not use unicode as a character set but only as
national character set it just unter unicode, question mark is inserted instead of special character. and again special characters from czech language is inserted correctly(i checked hexadecimal value enetered in table space and unicode value of question mark is inserted when i am trying to nter for example arabic special character so it is using unicode). I tried nearly any NLS_LANG setting on server side and client side. my NLS_LANG setting on server was for exampl AMERICAN_AMERICA.AL16UTF16 and i tried same thing on win but it was not working (i used standard nls character set for eastern and western european countries too) We need multilingual setting on client and server too. Any ideas? I have read globalization document from oracle, tons of faq and forums, some similar problems but none solution helped me. Please could u gimme some advice? Strange is that some special characters from some languages are accepted and from other languages they r not. thanks much, Tomas