topic Re: Unicode : Chinese in Application Development and Automation Discussions

Unicode : Chinese

Former Member — Thu, 21 Dec 2006 22:00:56 GMT

Hi ALL ,

Recently we moved to Unicode , and we are facing problem with an interface program for citybank

citybank -cityDirect specification is based on the field position in the flat file,it identifies fields from the field position.

File is downloaded to flat file with fields in the exact position , as it is specified in the internal table/ structure field length declaration .

<b>The issue .</b>

In Unicode system, the format of the file downloaded is disturbed because of Chinese characters in the file .

This is because Unicode system considers the length of a Chinese character as 1, even though it occupy 2 spaces/places compared to English ( in the flat file /Notepad ).

Ex:

ab ab ab ab

海 齐 尔 算 May be chinese is big and it is of 2 bytes where as english is 1 .

So when the user download the file in ANSI, the field length of field NAME1 ( which hold Chinese characters ) in the text file is increasing , and the entire file format is getting disturbed .

I know, I can count the bytes ,find out Chinese chr in the string , adjust the field length dynamically . But this does not seem to be standard solution.

Did anybody face this problem before?

Thanks for any reply ,

Re: Unicode : Chinese

Former Member — Thu, 21 Dec 2006 22:07:31 GMT

Hi,

Try using

SET LOCALE LANGUAGE lg.

Read the documentation for SET LOCALE for more details..

Thanks,

Naren

Re: Unicode : Chinese

Former Member — Thu, 21 Dec 2006 22:18:37 GMT

please read the question

Thanks any way for your reply.

Re: Unicode : Chinese

Former Member — Thu, 21 Dec 2006 22:34:41 GMT

Hi,

Search in SDN forum with the keyword Unicode...I am getting lot of forums regarding those..

Thanks,

Naren

Re: Unicode : Chinese

Former Member — Thu, 21 Dec 2006 22:37:36 GMT

I did , but nothing relevant.

Thanks

Re: Unicode : Chinese

Former Member — Thu, 21 Dec 2006 22:48:13 GMT

Hi,

Try with the key word Chinese..

Thanks,

Naren

Re: Unicode : Chinese

Former Member — Thu, 21 Dec 2006 22:51:49 GMT

Thanks , I did all searches before posting , even in customer market place.

Re: Unicode : Chinese

Former Member — Fri, 22 Dec 2006 07:38:54 GMT

hello Freney,

i have faced the same issue for russia..wht i did for tht is i translated the Russian Cyrillic Characters into LAtin characters and then moved them to table ...

now thing is tht u have to code how to convert the Chineese characters into latin characters..i m sure once this is done it will work..

amit

Re: Unicode : Chinese

Clemenss — Sat, 23 Dec 2006 00:24:48 GMT

Hi,

I don't understand fully: If you download using unicode characters then all characters regardless of chinese or not should occupy 2 bytes. How do you change encoding within the record?

It won't be possible to convert to latin without losing information.

Regards,

Clemens