Can't Export Double-Byte Characters.

[gnought]

I entered some double-byte characters (e.g. Chinese) in Project::comment fields. The data in the fields appear "?" when exporting transactions to Excel or Plain Text format.

Would there be any fix?

 

[stanbusk]

iCash is Unicode UTF8 and saves its files that way. Excel doesn't support Unicode. You can try converting the encoding with TextWrangler (Mac).

 

[gnought]

I tested iCash storing data in Unicode. Exporting xml / sql is not a problem, but the non-Latin data appear "?" while exporting plain text. If the data becomes "?", I doubt that how I could change the encoding to change "?" to display correctly. Would you think that it is a bug?

 

[stanbusk]

What program do you use to open the exported file?

 

[gnought]

The extension of exported file is ".txt". I used Notepad to open it.

 

[stanbusk]

Notepad doesn't support encodings. It will open the raw source of the file. Perhaps I will have to modify iCash and stop using Unicode.

 

[gnought]

I think the exported plain text should be in UTF-8, do you know the BOM (byte order mark)? Added the BOM at the start of text stream can tell the ".txt" be encoded in UTF-8.

 

[stanbusk]

Actually we use Unicode UTF-8 with no BOM. Do you think adding a BOM would fix the Excel issue? I tried a few months ago it was worst.

 

[gnought]

maybe we should deal with the plain text first. Here I attached the screenshot for elaborating more.
Maybe I could deal with this issue more if I know what language is iCash written in.

 

[gnought]

Any idea about this issue?

 

[stanbusk]

I will have a look.

 

[gnought]

It seems that the problem also occurs while exporting to qif.

 

[stanbusk]

Is the iCash language the same as your system language and the language used in the data? Any discrepancy?

 

[gnought]

My System Language is English,
and the language for non-Unicode programs is Chinese.

The language of iCash is English.

iCash: v6.6.1
OS: Windows 7 (64 bit)

 

[stanbusk]

Why is the language for non-Unicode is set to Chinese?

 

[gnought]

As I am running some non-Unicode programs that UI language is Chinese.

 

[stanbusk]

I believe the problem comes from that. The iCash language, content language and system language have to be the same. I will have to investigate that and see if it can be done a different way, offering for example a way to set the export encoding.