Crystal Report 9 vs. Vietnamese Unicode Pre-combound (TCNV 6909:2001 with Vietkey2000)

Dear ladies and gentlements,

I have some a big problem with Crystal Report 9 while developing some reports with IBM Lotus Domino Release 6.

First, let me introduce Vietnamese Unicode to you. Microsoft Windows, and a lot of organizations certify that Vietnamese Windows (CP 1258) is a Vietnamese Unicode standard. Vietnamese Windows (1258) arranges Vietnamese fonts as the following:

  • 02 bytes for indicating characters. ie: a, b, ê, …

  • 02 bytes for indicating accents. ie: ~(tilde), ',`,…

ễ is arranged into ê (character) and ~ (accent)

ie: ễ is arranged into: ê (EAH):̃(303H)

There is a Vietnamese Unicode stardard which has been established by an Vietnamese Organization. It is called Vietnamese Pre-Compound Unicode. To indicate a full character (include accents), this standard find a character in the Unicode table, and then, assign that code for this character. ie: ấ, ắ, ẵ, …

ie: ễ (1EC5H) with Vietkey2000.

So, there are some non-correct results occurring when using Microsoft Word with Vietnamese Pre-Compound Unicode. ie: can’t do “UPPERCASE” (Format/Change Case …/UPPER CASE) with Vietnamese Pre-Compound Unicode.

ie: “nguyễn văn nhật nam” is transformed into “NGUYễN VĂN NHậT NAM” when do Format/Change Case …/UPPERCASE in Microsoft Word.

And we encounter a big problem when developing an application based-on IBM Lotus Domino Release 6: generating and viewing a report (designed with Crystal Report 9). It is not able to display Vietnamese Pre-Compound Unicode with Crystal Report 9, via Lotus Notes Native Driver (crdb_p2snote.dll, nextpwd.dll, lcppn201.dll) or via NotesSQL 3.02. ie: ấ (in Vietnamese Pre-Compound Unicode) is interpreted into â’ or â? or â-.

ie: " ấ " is displayed as " â’ " when viewing.

Please show us how to repair that problem!

Thanks you very much!

Hope to receive your responses as soon as possible!

Nhat Nam. (nhatnamnv@yahoo.com)

Subject: Crystal Report 9 vs. Vietnamese Unicode Pre-combound (TCNV 6909:2001 with Vietkey2000)

Unfortunately, NotesSQL does not support Unicode.

Ron

Subject: RE: Crystal Report 9 vs. Vietnamese Unicode Pre-combound (TCNV 6909:2001 with Vietkey2000)

NotesSQL 3.01A and above supports Vietnamese Unicode (Vietnamese Windows - CP 1258). Thanks!

Subject: RE: Crystal Report 9 vs. Vietnamese Unicode Pre-combound (TCNV 6909:2001 with Vietkey2000)

No, you are wrong, NotesSQL does not support Unicode! I know this for a fact. NotesSQL will return data back in Notes LMBCS format, (http://www-12.lotus.com/ldd/doc/tools/c/6.0.2/api60ref.nsf/852561bd0045e8e785255b3c005a57bb/00d8002a0052009785255e8e007628c5?OpenDocument), but this is not Unicode.

Ron