Re: Use Greek Characters

> Hi,
> Try put string EL8ISO8859P7
> into (Regedit)
> HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE -> NLS_LANG
I am afraid this is wrong! Changing the registry DOES NOT affect the database - it affects the way data are treated by client applications (e.g. SQL*Plus, your application talking to Oracle, etc.).

If you do this, your database (which is created with WE8ISO8859P1) will think it contains western european data, while your application will send greek data. In effect, you are able to store and see greek data from your application (provided that you use greek fonts) but all operations which are dependent to character set will be performed in western european. This means that you will have problems with sorting, representation of dates, etc.

To change the database character set you must recreate it or use ALTER DATABASE CHARACTER SET command (under some restrictions).

GT Received on Sat Mar 16 2002 - 18:18:35 CET