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