| regarding character set [message #61110] |
Tue, 30 March 2004 01:32  |
vinod jose
Messages: 3
Registered: March 2004
|
Junior Member |
|
|
is it possible for migration of utf8 character set to
us7ascii.please give the steps for conversion.
the problem faced by me is hextoraw function
is not working correctly in utf8 whereas it
is working properly in us7ascii.
for example in utf8 character set -
SQL> select rawtohex('A') from dual;
RA
--
41
SQL> select hextoraw('41') from dual;
HE
--
41
any suggestions would be of great help.
|
|
|
|
| Re: regarding character set [message #61111 is a reply to message #61110] |
Tue, 30 March 2004 01:57  |
Anatol Ciolac
Messages: 113
Registered: December 2003
|
Senior Member |
|
|
|
It is possible to export dates, than recreate database with characterset, that your need, and import dates. You could not change a characterset of database other kind. If imp utility write that could not perform import due to character set conversing, set hidden parameter _tts_allow_nchar_mismatch = true (work on Oracle 9 - I am not tested on Oracle 8) and import will perform.
|
|
|
|
| Re: regarding character set [message #61133 is a reply to message #61111] |
Tue, 30 March 2004 20:27 |
vinod jose
Messages: 3
Registered: March 2004
|
Junior Member |
|
|
hi anatol,I tried, but when i am importing i get
IMP-00077: Could not convert to server national character set's handle.
IMP-00000: Import terminated unsuccessfully.
i am using oracle9.2.0 version with utf8 characterset ,
i want to import in 9.0.1 version with us7ascii characterset.
|
|
|
|
| Re: regarding character set [message #61134 is a reply to message #61133] |
Tue, 30 March 2004 20:48 |
Anatol Ciolac
Messages: 113
Registered: December 2003
|
Senior Member |
|
|
|
Try at first to export in 9.2.0 with us7ascii and then export and import to 9.0.1 with us7ascii. You must to know that generally if table contain NVARCHAR2(or NCHAR) column, he could not to exported into database other with other characterset. You also can try to generate insert's for every row in your table in 9.2.0 and then run them in 9.0.1 database(or make insert as select via dblink).
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
