handling Japanese (UTF-8?) text with Rev, CGI, & MySQL

[Trevor DeVore]

On Feb 21, 2008, at 4:40 AM, Nicolas Cueto wrote:

> Everything works fine except for the displaying in a text-field
> of the downloaded data. The English text arrives fine, but the
> Japanese text appears as one question mark per character.
>
> I'm including below what I think is the relecant information,
> namely, the MySQL table structure, the Rev-CGI script,
> and the stack-script.
>
> Any ideas how to handle the Japanese text so that it'll appear
> correctly? I've already tried a combination of collations (UTF-8,
> and shift-jis), "Content-Type", "charset=", and Rev unicode
> decoding/encoding/HTMLtext commands, but I can't seem to
> hit upon the right mix.

If your Japanese text is encoded with shift-jis then try converting  
the text from shift-jis to unicode and then setting the unicodeText of  
the field. Maybe this will work:

on mouseUp
     put field "fURL" into tURL
     get url tURL
     get uniencode(it, "Japanese")
     set the unicodetext of field "fResult" to it
end mouseUp

Regards,

-- 
Trevor DeVore
Blue Mango Learning Systems
www.bluemangolearning.com    -    www.screensteps.com