Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

character Set

Status
Not open for further replies.

khm123

Programmer
Joined
Oct 20, 2003
Messages
6
Location
QA
I created my database with character set as WE8ISO8859P1 but I need to change it to AR8MSWIN1256
 
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.
 
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
 
Note that the ALTER DATABASE command will fail unless the target character set is a strict superset of the source character set.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top