RE: XML in Canadian French/English

["Rowe, Sheri" <srowe@xxxxxxxxx>]

Thanks Scott and Bruce!!!

Will look into this solution.

Sheri 

-----Original Message-----
From: Scott Klement [mailto:midrange-l@xxxxxxxxxxxxxxxx] 
Sent: Friday, November 20, 2009 1:16 PM
To: Midrange Systems Technical Discussion
Subject: Re: XML in Canadian French/English

Hi Sheri,

After your upload, do:

CHGATR OBJ('/path/to/IFS/file.xml') ATR(*CCSID) VALUE(1208)

It would appear that your file is encoded in UTF-8 (which is good) and 
when you upload it, you are using binary mode (which is also good).  The 
problem is that the operating system doesn't KNOW that the data is 
UTF-8.  You've left it set to the default CCSID of 819 (ISO-8859-1 -- a 
flavor of ASCII).  You need to tell it that your file is UTF-8.

That's what the CHGATR command above does.  It sets the CCSID of the 
file to 1208 (which is UTF-8).

Good luck

Rowe, Sheri wrote:
> Hi,
>
> I am FTPing an XML file from our web site to our iSeries and when the file arrives on the iSeries the French accents are changed.  I have tried a bunch of different CCSID'S but still can't get it to work.
>
> Does anyone have any suggestions?
>
> Here is what is on the web site
>
> <ship_to_address2> Montréal </ship_to_address2>
>
> Here is what I get on the iSeries
>     
>  <ship_to_city> Montréal </ship_to_city>
>
> TIA.
>
> Sheri