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