PHS IT
asked on
Vietnamese language on System i Access
Hello,
I have no problem to input Vietnamese charcater in to AS400 client. But when i do data transfer and export to excel file, some characters are not correct (like some characters below should have a "dot" but is not showing).
And i find out there is language setting in the System i Access(see attachment) but no Vietnamese language to select.
Any suggestion?
Thanks
Wayne
System-i-Access.jpg
I have no problem to input Vietnamese charcater in to AS400 client. But when i do data transfer and export to excel file, some characters are not correct (like some characters below should have a "dot" but is not showing).
And i find out there is language setting in the System i Access(see attachment) but no Vietnamese language to select.
Any suggestion?
Thanks
Wayne
System-i-Access.jpg
ASKER
Hi Gary,
This file is coded 65535 (please refer to screen1)
However, the Vietnamese user is able to view this Vietnamese in AS400, but after export to excel file some words are wrong. (please refer to screen2)
I have enabled Vietnamese language in Micosoft Office Tools.
What do i need to set on the DTF to excel?
Many thanks.
Wayne
Screen1.png
Screen2.png
This file is coded 65535 (please refer to screen1)
However, the Vietnamese user is able to view this Vietnamese in AS400, but after export to excel file some words are wrong. (please refer to screen2)
I have enabled Vietnamese language in Micosoft Office Tools.
What do i need to set on the DTF to excel?
Many thanks.
Wayne
Screen1.png
Screen2.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Gary,
After we do some testing, now we have no problem with enter and view Vietnamese language in the AS400 client, it's work perfectly.
Now the only problem is, when we need to export the data (DTF) to ecxcel file. Some character cannot display correctly.
Any suggestion?
Many Thanks
Wayne
After we do some testing, now we have no problem with enter and view Vietnamese language in the AS400 client, it's work perfectly.
Now the only problem is, when we need to export the data (DTF) to ecxcel file. Some character cannot display correctly.
Any suggestion?
Many Thanks
Wayne
Wayne,
Isn't that the same problem you originally posted?
Please see my responses above and supply the requested information and I'll be happy to help you.
- Gary
Isn't that the same problem you originally posted?
Please see my responses above and supply the requested information and I'll be happy to help you.
- Gary
ASKER
Hi Gary,
Sorry for the late reply, as i'm also asking around from my internal IT. You are right, we need to find out what is the CCSID we should use for Vietnamese language. Finally we find out CCSID for Vietnamese is 1130 and we setup CCSID 1130 into AS400 profile. Now it is working well on viewing or DTF.
Thanks for your help
Wayne
Sorry for the late reply, as i'm also asking around from my internal IT. You are right, we need to find out what is the CCSID we should use for Vietnamese language. Finally we find out CCSID for Vietnamese is 1130 and we setup CCSID 1130 into AS400 profile. Now it is working well on viewing or DTF.
Thanks for your help
Wayne
When you do a data transfer from the IBM i to Excel, the Data Transfer tool inspects the CCSID associated with each column that can contain character data and attempts to convert it.
If the source column uses CCSID 65535 (means "do not translate"), then you have to manually specify translation parameters so the system knows which translation table to use.
On IBM i, Vietnamese characters can be encoded in Unicode (UTF-8, UCS-2, or UTF-16), or one of several single-byte (SBCS) and double-byte character sets (DBCS).
What CCSID is associated with the problem database column? You can find this using the DSPFFD command.
Also, Vietnamese language support needs to be enabled in Microsoft Office Tools.
- Gary Patterson