Unicode Displaying in Runtime Revolution #2

[Marisa K.]

Hello Trevor,

Thank you so much for your reply.

I had tried on your suggestion(using cursors) but it didn't work with 
me, still. While, English texts can be displayed just fine, Thai's texts 
cannot.

Well, I connect to the database through ODBC. Do you think this is where 
the problem is?

Every suggestions are welcome as I'm willing to try.

Regards,
Marisa

Trevor DeVore wrote:

> On Apr 20, 2005, at 10:30 PM, Marisa. wrote:
> Hmm, this worked in a test I did last night using MySQL on some UTF8 
> encoded data.  The only difference is that I used cursors 
> (revQueryDatabase and revDatabaseColumnNamed).  Perhaps try that and 
> see if it changes results at all.  I'm not sure why it would but you 
> never know.
>
>> Hi Trevor,
>>
>> Thank you agian for your suggestion. You are right about the database 
>> of UTF-8. :-)
>>
>> However, I've tried on that, too, but the result is the same!!
>>
>> I wrote script as:
>>
>> on openCard
>>  global tID
>>  set the unicodeText of fld testDB to uniEncode( revDataFromQuery (, 
>> return, tID, "SELECT cityLocalName FROM POSTAL_CODE_TABLE"),"utf8")
>> end openCard
>>
>> Am I doing sth wrong with the script? Also, I used to try on ;
>>
>> put revDataFromQuery (, return, tID, "SELECT cityLocalName FROM 
>> POSTAL_CODE_TABLE") into tCityThai
>> set the unicodeText of fld TestDB to uniEncode (tCityThai, "utf8")
>>
>> The result is the same! Then, i thought 'binfile' may help. So, I 
>> saved the result from revDataFromQuery directly as binfile. However, 
>> when I open it, the result was wrong. Anyway, I tried to put its 
>> content to field with unicodeText settings and uniEncode.
>>
>> put revDataFromQuery (, return, tID, "SELECT cityLocalName FROM 
>> POSTAL_CODE_TABLE") into URL "binfile: tCityThai.txt"
>> set the unicodeText of fld TestDB to uniEncode(URL "binfile: 
>> tCityThai.txt", "utf8")
>>
>> The result is the same, too.
>>
>> Any suggestions?
>>
>> Regards,
>> Marisa 
>