Unicode Displaying in Runtime Revolution #2

[Marisa K.]

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


Trevor DeVore wrote:

> Marisa,
>
> I imagine your database is storing the text as UTF8.  Revolution 
> fields use UTF16.  Setting the field using this:
>
> set unicodeText of fld "Unicode" to uniEncode(myDatabaseValue, "UTF8")
>
> This should display the characters correctly.
>
>