Powerbuilder export multi-language to Excel

[Former Member]

Hi

my application require to export chinese / japanese characters to excel.

but the output on exlce display as "????".

i have managed to input & display the chinese/japanese on the powerbuilder application ( pb12.5 classic ) and saved to oracle database but faced problems when exporting the data from datawindow to excel.

below are scripts.

gole_obj = create oleobject

gole_obj.ConnectToNewObject("excel.application")

lole_sheet = gole_obj.Application.ActiveWorkbook.WorkSheets[vin_cur]

lole_sheet.cells[1, llo_col] = String(Blob(ids_col_info.getitemstring(llo_col, "col_text"), EncodingUTF16LE!))

would appreciate any advise

Rgds,

Chee Boon

[Former Member]

Hello Chee,

Were you able to get this to work.  I managed to insert Japanese characters into Excel from PowerBuilder.  I wasn't able to use Oracle, so I used the SQLAnywhere Unicode sample database.  My Japanese characters were entered in a nvarchar column?  What is the data type that you're using in Oracle?

Ted Zimmerman