Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Vietnamese language on System i Access

Posted on 2013-12-09
6
Medium Priority
?
633 Views
Last Modified: 2014-02-20
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
0
Comment
Question by:IT-PHS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 35

Expert Comment

by:Gary Patterson
ID: 39708916
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
0
 

Author Comment

by:IT-PHS
ID: 39713489
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
0
 
LVL 35

Accepted Solution

by:
Gary Patterson earned 2000 total points
ID: 39714566
Wayne,
 
The trick to get this to convert properly is to identify the actual CCSID that the text is actually encoded in.  

65535 is just a dummy CCSID that says "don't translate".

Please do a DSPPFM on the problem table, find some of the example rows, and press F10 to display the problem column in hex.  The more "before and after" examples you can post, the better.  Looking at the hex, we can figure out what the CCSID is.
0
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 

Author Comment

by:IT-PHS
ID: 39731143
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
0
 
LVL 35

Expert Comment

by:Gary Patterson
ID: 39731210
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
0
 

Author Comment

by:IT-PHS
ID: 39876034
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
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With the evolution of technology, we have finally reached a point where it is possible to have home automation features like having your thermostat turn up and door lock itself when you leave, as well as a complete home security system. This is a st…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question