On 2017-07-28 15:24, Trevor DeVore via use-livecode wrote:
SQL Yoga does not. I'm not familiar with the SET NAMES query so I don't
know what the down sides are.
None as far as I can see :)
See:
https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html
Basically SET NAMES and related SET commands in MySQL allow you to
configure the per-connection attributes which tell the MySQL server what
charset to send strings to the client in. MySQL 'knows' what charset
every string in its realm is encoded in, so can happily convert to any
other for specific clients - you just need to tell it what charset you
(as a client) are expecting.
In the case of SQLite its UTF-8 all the way down so the problem doesn't
come up.
Warmest Regards,
Mark.
P.S. I wasn't aware of the SET NAMES statement in MySQL until just now,
either :)
--
Mark Waddingham ~ m...@livecode.com ~ http://www.livecode.com/
LiveCode: Everyone can create apps
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode