mySQL and accented chars revisited

[Kay C Lan]

On Thu, Nov 5, 2015 at 8:59 AM, John Dixon <dixonja at hotmail.co.uk> wrote:

> I have just had a thought... How would you go about handling accented
> chars if you were put in the position of using a mySQL database, belonging
> to someone else,  that had never seen liveCode before ?
>
> The same still applies. If any db Admin utility can look at the mySQL db
and the data appears correctly, then if you textDecode data you SELECT then
it will appear in your LC app correctly. If you textEncode the data before
you UPDATE or INSERT it back into the mySQL db then it will appear
correctly in all those other db Admin utilities.

Basically these other db Admin utilities should have been written to do the
equivalent of what you are required to do in LC. They should decode the
data for presentation on their particular platform - Win, Mac, Linux, and
encode any data they put back in.

HTH