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!

Register Log in
  • Congratulations strongm 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

khm123

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

Similar threads

gc6294
  • Locked
  • Question
Search for a character in Oracle SQL statement 1
Replies
3
Views
127
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in &quot;Description&quot; column of &quot;AP_INVOIC 2
Replies
5
Views
195
Livia8
Livia8
DeShaun
  • Locked
  • Question
Mutiple Where table in Update/Set
Replies
10
Views
148
fredericofonseca
fredericofonseca
Andrzejek
  • Locked
  • Question
ORA-06502 character string buffer too small 2
Replies
2
Views
103
Andrzejek
Andrzejek
yorge
  • Locked
  • Question
Return unique row from a given set of rows 2
Replies
3
Views
97
cmmrfrds
cmmrfrds

Part and Inventory Search

Sponsor

Back
Top