Importing Unicode from MySQL

[Kaveh Bazargan]

Hi Andy

That seems to work!! Boy what a journey. And thank you Devin for your help.

Regards
Kaveh

On 26 July 2017 at 08:03, AndyP via use-livecode <
use-livecode at 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.
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



-- 
Kaveh Bazargan
Director
River Valley Technologies
@kaveh1000
+44 7771 824 111
www.rivervalleytechnologies.com