Friday, December 01, 2006
OracleXE setting character set
As SYS user you must do the following steps:
SQLPLUS /NOLOG
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL> ALTER DATABASE OPEN;
SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE EE8MSWIN1250;
SQL> SHUTDOWN;
SQL> STARTUP;
SQL> QUIT;
Autor: v. monomakh, Krasnodar, Russia (from OTN)
On clients you must set NLS_LANG=SLOVENIAN_SLOVENIA.EE8MSWIN1250
# posted by Domen Dolar @ 10:51 AM 
