Text (uni)coding issue

andrew at midwestcoastmedia.com andrew at midwestcoastmedia.com
Sat Aug 26 21:44:12 EDT 2017

> - you need to know your database encoding (let?s assume UTF-8)

I was still fairly green to mySQL when I first created this database,  
so I never changed the default. Looks like the collation is  
"utf8mb4_unicode_ci". Should that be changed to something else? The  
server charset is UTF-8 Unicode (utf8) [HostM]

> - you need to write this file in an encoding you know so you can  
> decode it when you download:
> - you need to read the file and decode from the encoding you know it is in:
> put textDecode(url (?binfile:? & <local path>), ?UTF-8?) into tResults
> Disclaimer: this code has just been written into an email client  
> untested so may have some errors.

There were some errors (I think from email translations), but I think  
I understand what you're trying to do. The data still seems to be in a  
weird format.

--Andrew Bell

More information about the Use-livecode mailing list