View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.vb
HKSHK HKSHK is offline
external usenet poster
 
Posts: 1
Default Chinese characters - UTF8 CSV files

Hello Manju,

the problem is that VB6 does not support UTF-8.
If you want to append then maybe you can use this method:

1. Open the file as binary
2. Get the characters value (AscW) and write it into a long variable.
3. Get the upper and lower byte values and store them in 2 byte variables.
4. Write those byte variables into your file.
5. For Carriage Return and line feed you have to write the 10 and 13
manually.

Best Regards,

HKSHK

wrote:
Hi All,

I'm facing problem while showing the Chinese characters in CSV file.
I'm using Open for Append Access Write As method to create the CSV file
programmatically. If I set the CSV file character set to UTF-8 then I
can display the Chinese characters. But I'm not able to set the CSV
character set to UTF-8 programmatically.

I'm using VB6.0 for this.

If anybody knows this please let me know. Thanks a lot in advance.

With love,
Manju