Going even further out on a limb than I usually do ... Finally got a rev.cgi script that can connect and query a MySQL database (both on a web-server):
#!revolution on startup -- This is an edited example. put revOpenDatabase(...) into connectionID put "SELECT * FROM `tableNihongo`" into sql put revDataFromQuery(,,connectionID,sql) into vResults put vResults & return after buffer put "Content-Type: text/plain" & return put "Content-Length:" && the length of buffer & return & return put buffer end startup Problem is, when I use my HTML browser to call that rev.cgi script, the table's English elements are readable but not the Japanese. Browsing that table in phpMyAdmin, though, those Japanese elements get correctly displayed. I'm guessing this is an encoding issue, since the garbled Japanese appears as two question marks for each character. And so, I've been *blindly* trying different combinations of character sets in the table collations (sjis_japanese_ci & utf8_unicode_ci), adding a charset for the script above (shift_jist & utf-8), and Rev's uniEncode/uniDecode commands. An obscure question, but... Thank you for your attention. -- Nicolas Cueto _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
