There are tow things you should check:
- What is Your Database character set? it must support UTF8 - Unicode. I
using AL32UTF8. When you create new database you must chouse it.
- The second, this is on the machine that run the application, you set to display unicode character.
+ In Run menu type: regedit, press Ok
+ Find on: HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE -> HOME* -> NLS_LANG you change this value to "AMERICAN_AMERICA.UTF8".
Should I set NLS_Characterset=UTF8? If I do so, then I can use char, varchar... datatypes to store unicode data because the datatypes is 2 byte font. If everything is 2 byte font, I think that it is very expensive!!!
I'm an Oracle beginner, I want to receive many advices from everyone.