v7 Unicode and MySQL
Tim Selander
selander at tkf.att.ne.jp
Tue May 6 03:37:54 EDT 2014
Hi,
Wondering if anyone has used/tested v7 with a UTF8 MySQL database
yet?
My old handlers that relied on picking up a query using the
unicodeText, uniDecode, uniEncode, etc. work under v6 and
earlier, as well as under v7:
--fld "query" contains SQL query, mix of English & Japanese text
put the unicodeText of field "query" into locSQLParams
put uniDecode(locSQLParams, "UTF8") into locSQLParams
put revDataFromQuery(, , vDatabaseID, locSQLParams) into myResult
set the unicodetext of fld queryresults to uniEncode(myResult,
"UTF8")
Under v7 I was hoping to simplify the above script by avoiding
unicodeText, etc., but haven't hit on a working solution yet...
TIA
Tim Selander
Tokyo, Japan
More information about the use-livecode
mailing list