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.
_______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution