Dear all,
i installed database 10g with English language support
and imported a dump file contains tables having columns in arabic
so after search i did these steps
SHUT;
CONN SYS/SYS AS SYSDBA
STARTUP RESTRICT;
Alter database character set INTERNAL_USE AR8ISO8859P6; (for arabic) which we want.
SHUT;
STARTUP
after the previous steps
i checked on the nls_characterset from NLS_DATABASE_PARAMETERS and found it changed to AR8ISO8859P6
and that's right
after that i can insert any arabic character to the tables
but the original data still the same
is there anyway i can do to change the original data to be read in arabic
or i should make another import
thanks
] 
Blog
Search
Help
Members
Register
Login
Home
