ODBC encoding issue with chinese character under AIX 6.1
Moderators: chulett, rschirm, roy
ODBC encoding issue with chinese character under AIX 6.1
We tried both ODBC Enterprice stage and ODBC connector stage to
read data from MS SQL Server database into a sequential file.
For chinese characters, they can not be read correctly. We saw ? instead of
original chinese characters in the seqential file. But for ascii chacaters we have no problem.
I suspect it is an encoding issue but has no clue how to solve the problem.
Please shed some light on it. Thanks a lot!
read data from MS SQL Server database into a sequential file.
For chinese characters, they can not be read correctly. We saw ? instead of
original chinese characters in the seqential file. But for ascii chacaters we have no problem.
I suspect it is an encoding issue but has no clue how to solve the problem.
Please shed some light on it. Thanks a lot!
"They cannot read ..." where are you trying to read it from? Downstream database? Sequential file on your DataStage server?
If you are doing a "View Data" then please make sure that your local character set for your client machine can display your chinese character set. You could also try to open the file in HEX mode to see if the double byte (chinese character set) data looks ok.
If you are doing a "View Data" then please make sure that your local character set for your client machine can display your chinese character set. You could also try to open the file in HEX mode to see if the double byte (chinese character set) data looks ok.
I mean the chinese character can be read from the odbc data source
and written into the sequential file, but in the sequential file these chinese character become "?" instead of the one in the data source.
This is very likely to be an encoding issue, from my past experience.
I was wondering there must be a place to specify encoding in ODBC stage
, or odbc onfig file. But I can't find it now.
and written into the sequential file, but in the sequential file these chinese character become "?" instead of the one in the data source.
This is very likely to be an encoding issue, from my past experience.
I was wondering there must be a place to specify encoding in ODBC stage
, or odbc onfig file. But I can't find it now.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: