Importing Unicode from MySQL

[AndyP]

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.