issue reading arabic,french etc characters from database through cgi and setting in dropdown

shashwata

Hi,

 

we have a dropdown in dcr in which we need to need to set the value from database.

we are calling a cgi from formapi in which we are getting the vale and using parent.getscriptframe we are setting the options in the calling item.

it works fine for english but in arabic, it prints ????? in the log as well as in the dropdown.

for french, it prints correctly in the log file ( with accent etc ) but it is not able to set options in the dropdown.

the database encdoing is default for sql ucs-2.

we have tried using html::entities and encode decode but no success yet.

any pointer will be helpful.

 

Thanks.

Rick Poulin

I'm not sure that ucs-2 was the best choice of encoding, but that's probably the reason why your characters are coming out mangled. Make sure you explicitly configure your callout to read from the database in ucs-2 and write out as UTF-8. You may need to use the Encode module to explicitly do the conversion.

 

If that still doesn't work, you can try converting the special chars to their JavaScript escaped unicode version via the pack/unpack functions. I.e. print iwItem.setValue("\x00A9") instead of iwItem.setValue("©").