hak_shaolin
asked on
Oracle Character set
I have two application.
one is HRACCESS tool by IBM,using WE8ISO859PI character Set
second is Oracle Financial Application, using AR8ISO8859P6.
I want to insert into a table(Table FIN) in FInancials Appllication which is getting the date from HR ACCESS table(TABEL HR).Both the tables contains a column which stores arabic characters.
When i insert into Table FIN from table HR ,for that particular column it shows my ??? marks...like this.I coudn' get the data for this column.
Why it's haappening?Is there any chance to clear this problem?
Please help me.
one is HRACCESS tool by IBM,using WE8ISO859PI character Set
second is Oracle Financial Application, using AR8ISO8859P6.
I want to insert into a table(Table FIN) in FInancials Appllication which is getting the date from HR ACCESS table(TABEL HR).Both the tables contains a column which stores arabic characters.
When i insert into Table FIN from table HR ,for that particular column it shows my ??? marks...like this.I coudn' get the data for this column.
Why it's haappening?Is there any chance to clear this problem?
Please help me.
Hi,
you need to migrate to first database to a new character set. steps needed to be performed are:
connect sys as sysdba;
shutdown immediate;
--make a full backup of your database, it's just a suggestion
startup open;
alter database character set 'UTF8';
alter database national character set 'UTF8';
shutdown immediate;
startup open;
now it should work. Note that you cannot rollbakc this migration of the caracter set and also it's possible to do it just to a superset.
see the link http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/server.901/a90236/appa.htm#974236 for details of subsets and supersets
best regards,
Marius Nicoras
you need to migrate to first database to a new character set. steps needed to be performed are:
connect sys as sysdba;
shutdown immediate;
--make a full backup of your database, it's just a suggestion
startup open;
alter database character set 'UTF8';
alter database national character set 'UTF8';
shutdown immediate;
startup open;
now it should work. Note that you cannot rollbakc this migration of the caracter set and also it's possible to do it just to a superset.
see the link http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/server.901/a90236/appa.htm#974236 for details of subsets and supersets
best regards,
Marius Nicoras
Hi!
You need not migrate database!!!
You may use CONVERT function.
Purpose
CONVERT converts a character string from one character set to another.
The char argument is the value to be converted.
The dest_char_set argument is the name of the character set to which char is converted.
The source_char_set argument is the name of the character set in which char is stored in the database. The default value is the database character set.
Both the destination and source character set arguments can be either literals or columns containing the name of the character set.
For complete correspondence in character conversion, it is essential that the destination character set contains a representation of all the characters defined in the source character set. Where a character does not exist in the destination character set, a replacement character appears. Replacement characters can be defined as part of a character set definition.
Example
SELECT CONVERT('Groß', 'US7ASCII', 'WE8HP')
"Conversion" FROM DUAL;
Conversion
----------
Gross
Best regards!
Yaroslav.
You need not migrate database!!!
You may use CONVERT function.
Purpose
CONVERT converts a character string from one character set to another.
The char argument is the value to be converted.
The dest_char_set argument is the name of the character set to which char is converted.
The source_char_set argument is the name of the character set in which char is stored in the database. The default value is the database character set.
Both the destination and source character set arguments can be either literals or columns containing the name of the character set.
For complete correspondence in character conversion, it is essential that the destination character set contains a representation of all the characters defined in the source character set. Where a character does not exist in the destination character set, a replacement character appears. Replacement characters can be defined as part of a character set definition.
Example
SELECT CONVERT('Groß', 'US7ASCII', 'WE8HP')
"Conversion" FROM DUAL;
Conversion
----------
Gross
Best regards!
Yaroslav.
ASKER
when i give WE8ISO859PI(in Source or destination), it shows
ERROR at line 1:
ORA-01482: unsupported character set
this error.
what can i do?
ERROR at line 1:
ORA-01482: unsupported character set
this error.
what can i do?
Hi!
Check youare write in charset. It seems you mistakenly write it.
May be - WE8ISO8859P1.
you may check valid character set by select from table v$nls_valid_values.
Hope it helps,
Yaroslav.
Check youare write in charset. It seems you mistakenly write it.
May be - WE8ISO8859P1.
you may check valid character set by select from table v$nls_valid_values.
Hope it helps,
Yaroslav.
ASKER
sorry in thetion i have typed wrong. It is WE8ISO8859P1 only..
I have tried with the correct one.Anyway it is giving me the same error.
I have tried with the correct one.Anyway it is giving me the same error.
Could you post here exactly you command wich lead to error and database charset where you run it.
Yaroslav.
Yaroslav.
ASKER
command 1:
SQL> select convert('ÔÓÔÓ','WE8ISO859P
ERROR at line 1:
ORA-01482: unsupported character set
command 2:
SQL> select convert('ÔÓÔÓ','AR8ISO8859
ERROR at line 1:
ORA-01482: unsupported character set
The characters are "ARABIC" Characters.
SQL> select convert('ÔÓÔÓ','WE8ISO859P
ERROR at line 1:
ORA-01482: unsupported character set
command 2:
SQL> select convert('ÔÓÔÓ','AR8ISO8859
ERROR at line 1:
ORA-01482: unsupported character set
The characters are "ARABIC" Characters.
You doesn't write you database charset.
select value from v$nls_parameters
where parameter='NLS_CHARACTERSE
Yaroslav.
select value from v$nls_parameters
where parameter='NLS_CHARACTERSE
Yaroslav.
ASKER
in HRACCESS the database charset is WE8ISO8859P1.
in Oracle Applicatin the database charset is AR8ISO8859P6.
I want to insert date from HR access to Oracle Applicaton which contains the arabic data.
in Oracle Applicatin the database charset is AR8ISO8859P6.
I want to insert date from HR access to Oracle Applicaton which contains the arabic data.
Hi!
I test this on my server - it works fine.
In you example I see again error:
SQL> select convert('ÔÓÔÓ','WE8ISO859P
you missed one digit (8).
Please, carefully check your select statement.
Yaroslav.
I test this on my server - it works fine.
In you example I see again error:
SQL> select convert('ÔÓÔÓ','WE8ISO859P
you missed one digit (8).
Please, carefully check your select statement.
Yaroslav.
ASKER
i have checked with this query..but i get the result like this.
SQL> select convert('ÔÓÔÓÔÓ','AR8ISO88
CONVER
------
??????
what can i do?
SQL> select convert('ÔÓÔÓÔÓ','AR8ISO88
CONVER
------
??????
what can i do?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER