Japanese characters not displaying in DCR dropdown

JoeS

We're having trouble pulling in Japanese characters into a DCR drop-down field from an Oracle database. The characters are fine in the database table but in the DCR drop-down they appear as ?????.

[PHP]

[/PHP]

ISCBorisB

We're having trouble pulling in Japanese characters into a DCR drop-down field from an Oracle database. The characters are fine in the database table but in the DCR drop-down they appear as ?????. [PHP] [/PHP]

The reason is simple. Inline passes data through STDOUT. That's where your Unicode multi-byte symbols
get FUBARed (actual single-byte(!) symbol mapping depends on your Platform, for Windows it's Code Page 850).

Unfortunately, it is not easy to fix, not within inline API anyway. In my opinion, the easiest way to do it
is on DCR level, using either callServer or perhaps custom callout. If you do it this way, make sure you add
UTF-8 charset directive to "Content-Type" http Reply Header or corresponding HTML Meta.

If you want to stay with inline, you may perhaps recalculate multi-byte characters to Unicode Code Points
and use XML numeric entities. That (being ASCII) will go as is through system streams. I do not know
how well numeric entities may work in DCR drop-downs though, never tried.