| Double Byte Problem [message #61434] |
Thu, 22 April 2004 22:17  |
PagInit
Messages: 9
Registered: January 2004
|
Junior Member |
|
|
I have issue with Japanese double byte character.
Daily we are extracting data from MFGPRO to ORACLE via INFORMATICA. We have test as well as Production environment.
This Japanese double byte characters are stored properly in Test oracle database but incorrect in PRODUCTION database. Software version in both Test and Production are same.
For Example:
Test Database
SONY;SONY PRECISION TECH;JPC1103400; ;C1103400-4140;OEM;BRONZE;JPY;FCA|N25EON4M?-92-2897?-93-4350|| |"Ñ"C;10-DATA;C1103400-4140;SONY PRECISION TECH; ;?_"Þ?ÌŒ§ˆÉ?¨Œ´ŽS-É?Ì45;ˆÉ?¨Œ´?H‹Æ’C’N; ; ;259-1146;JAPAN; ; ;OPEN;0;1;0;
Production Database
SONY;SONY PRECISION TECH;JPC1103400; ;C1103400-4140;OEM;BRONZE;JPY;FCA|N25EON4M?-92-2897?-93-4350|| |SC;10-DATA;C1103400-4140;SONY PRECISION TECH; ;_`n)
The above red bold characters are properly stored in oracle test database but are incorrect in Production database.
Is the problem with oracle database or Informatica?
Can anyone Please help me on this problem.
Thanks in Advance,
Paginit
|
|
|
|
|
|
| Re: Double Byte Problem [message #61437 is a reply to message #61435] |
Fri, 23 April 2004 00:35  |
PagInit
Messages: 9
Registered: January 2004
|
Junior Member |
|
|
|
We are using Informatica for transfering data from MFGPRO to oracle.Informatica Mapping's will take care for insertion. Character set and national character set are similar in both the database.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
