Importing Unicode from MySQL

Kaveh Bazargan kaveh at rivervalleytechnologies.com
Tue Jul 25 18:48:22 EDT 2017


Hi Devin

Thanks for that. I just tried it and

*Bodø River*

becomes

*Bod River*

I was wondering at what point the Unicode is lost. So is it still intact
when it is saved as a variable? and is it then lost when the variable is
put into a field?

By the way the BYU documentation is the best on LiveCode. ;-)


On 25 July 2017 at 23:28, Devin Asay via use-livecode <
use-livecode at lists.runrev.com> wrote:

> Kaveh,
>
> The unicodeText property and uniEncode function are deprecated. Instead
> use textDecode as follows:
>
> Download your database data into a variable like tStringFromDatabase. Then,
>
> put textDecode(tStringFromDatabase,”UTF8”) into field “myDBText”
>
> HTH
>
> Devin
>
>
> On Jul 25, 2017, at 4:24 PM, Kaveh Bazargan via use-livecode <
> use-livecode at lists.runrev.com<mailto:use-livecode at lists.runrev.com>>
> wrote:
>
> I know this has been discussed before and I have tried to search for the
> answer, but no success.
>
> I am using LiveCode Community, 9.0.0 DP5 on Mac
>
> I have a MySQL database where all fields are formatted as UTF8. I do a
> query from LiveCode, and put the result in a field and I lose the non ascii
> characters.
>
> I am reading the result into whole_table.
>
> I then tried this:
>
> set the unicodeText of field "whole table" to uniEncode(whole_table,"UTF8")
>
> but the non-ascii characters disappear.
>
> any ideas pls
>
> --
> Kaveh Bazargan
> Director
> River Valley Technologies
> @kaveh1000
> +44 7771 824 111
> www.rivervalleytechnologies.com<http://www.rivervalleytechnologies.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
>
> Devin Asay
> Director
> Office of Digital Humanities
> Brigham Young University
>
> _______________________________________________
> 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



More information about the Use-livecode mailing list