Re: mySQL and accented chars revisited

On Thu, Nov 5, 2015 at 8:59 AM, John Dixon 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 ? > > Sorry, I should have made one othe

Re: mySQL and accented chars revisited

Kay's right. You can define the encoding to be used in an SQL database and utilities should observe that encoding by default. I added that in the last release of my SQLiteAdmin program, although I also included preferences to not encode/decode and/or specify an encoding. That's necessary because t

Re: mySQL and accented chars revisited

On Thu, Nov 5, 2015 at 8:59 AM, John Dixon 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 Ad

Re: mySQL and accented chars revisited

I agree, it is strange it's not in the textEncode entry, never noticed that. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Wed, Nov 4, 2015 at 5:06 PM, Kay C Lan wrote: > As

Re: mySQL and accented chars revisited

It would depend if they had been properly encoding the data in the database or not. If yes, then using textDecode when SELECTing should get you the correct results. If no, you'd need to do the one-time conversion I described (assuming it works of course!). Pete Pete lcSQL Software

Re: mySQL and accented chars revisited

As Peter says. This statement appears in the textDecode entry in the Dictionary but for some strange reason not in the textEncode entry. It says it all: It is highly recommended that any time you interface with things outside LiveCode (files, network sockets, processes, etc) that you explicitly te

RE: mySQL and accented chars revisited

Yes I am using LC7... I should have mentioned that... Peter, thank you for your suggestion, I will try that..:-) 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 see

Re: mySQL and accented chars revisited

Hi John, Sounds like you're using LC7 since I see textDecode in there. I don;t know enough about the URL side of things but I think the issue on the database side is what you are doing when you INSERT or UPDATE the data. It needs to be textEncoded at that point. After that, you need to textDecod