Andy, Thanks for that tip. It’s one I never have heard about. I’ll try this next time I need to read UTF8 from my db.
Devin On Jul 26, 2017, at 1:03 AM, AndyP via use-livecode <use-livecode@lists.runrev.com<mailto:use-livecode@lists.runrev.com>> wrote: I had the same problems a while ago, but got it sorted with the following. *Before* you do any interactions with the db, add this line. *revExecuteSQL MyConnectionID, "SET NAMES 'utf8'"* "SET NAMES 'utf8'" is needed whenever you want to send/retrieve data to/from the server having characters that cannot be represented in pure ASCII, like 'ñ' or 'ö'. Then retrieve the data *put textDecode("SELECT * FROM MyTable","UTF-8") into fld "MyField"* ----- Andy Piddock My software never has bugs. It just develops random features. TinyIDE a Free alternative minimalist IDE Plugin for LiveCode TinyIDE Script editor Themer for LC http://2108.co.uk PointandSee is a FREE simple but full featured under cursor colour picker / finder. http://www.pointandsee.co.uk - made with LiveCode -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Importing-Unicode-from-MySQL-tp4717480p4717487.html Sent from the Revolution - User mailing list archive at Nabble.com<http://Nabble.com>. _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com<mailto:use-livecode@lists.runrev.com> Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode Devin Asay Director Office of Digital Humanities Brigham Young University _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode