| thushara |
Posted: Jul 02, 2008 04:30:49 AM |
Total Post: 3
Joined: Jun, 2008
|
I have a 9i database with character set WE8ISO8859P1 and I need to migrate this database to 10g with character set AR8MSWIN1256 (character set AR8MSWIN1256 is needed as Application Server is not working properly)
I used export/import where I exported the 9i database by setting NLS_LANG to the same database character set and imported to the 10g database with the new characterset.
but my arabic characters are not getting displaying in SQL *PLUS, all the arabic letters are coming in junk (???? amrks)
I have set the NLS_LANG=AMERICAN_AMERICA.AR8MSWIN1256 in my client pc and nothing is working please help
|
|
|
 http://shaharear.blogspot.com |
| Posted: Jul 02, 2008 05:18:41 AM |  |
|
Total Post: 135
Joined: Apr, 2008
|
please go through this :
http://shaharear.blogspot.com/2008/04/changing-character-sets-of-database.html
|
|
|
|
|
| thushara |
| Posted: Jul 02, 2008 05:40:00 AM | |
|
Total Post: 3
Joined: Jun, 2008
|
Hi Thanks and I went through the url
But I need to change from WE8ISO8859P1 to AR8MSWIN1256. When I tried, it gave me the below error:
SQL> ALTER DATABASE CHARACTER SET
2 AR8MSWIN1256;
ALTER DATABASE CHARACTER SET
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set
Of course, This method is not possible. as AR8MSWIN1256 is not a supser set. So I can not use the given method.
When I tried the export and import to do this. only the arabic data I imported is in ??? marks but I can insert a new arabic character and it is displaying without any issues.
|
|
|
|
|
| MOH_DBA |
| Posted: Jul 03, 2008 02:42:54 PM | |
|
Total Post: 186
Joined: Nov, 2007
|
did you tried to create 10g database with this characterset:
AR8ISO8859P6 OR UTF8 or AL32UTF8 and set the nls_lang in the client too?
|
|
|
|
|
| positive |
| Posted: Jul 04, 2008 12:59:41 AM | |
|
Total Post: 483
Joined: Jun, 2008
|
http://neworacledba.blogspot.com/
|
|
|
|
|
| thushara |
| Posted: Jul 06, 2008 04:33:25 AM | |
|
Total Post: 3
Joined: Jun, 2008
|
Hi,
Thanks for the reply. WE8ISO8859P1 is a superset of all the character set and AL32UTF8 is the ideal character set in this case. and I executed Character Set Scanner utility to ensure that I will not corrupt or lose any data. Seems to be fine and I will inform you once my test is done.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
