character Set

[khm123]

I created my database with character set as WE8ISO8859P1 but I need to change it to AR8MSWIN1256

 

[jocave]

Unless AR8MSWIN1256 is a strict superset of WE8ISO8859P1 (and I don't believe it is), I believe you'll have to create a new database instance and do a full export and import.

 

[sem]

Have you already tried

ALTER DATABASE <database> CHARACTER SET <AR8MSWIN1256>

???

If not yet, bacup your database and try it. In the worst case you'll have to restore

Regards, Dima

 

[jocave]

Note that the ALTER DATABASE command will fail unless the target character set is a strict superset of the source character set.