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