Re: Importing Unicode from MySQL

2017-07-28 Thread Mark Waddingham via use-livecode
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 SE

Re: Importing Unicode from MySQL

2017-07-28 Thread Bob Sneidar via use-livecode
Well it wouldn't matter for sqlite, only for mySQL methinks, and if it is connection specific, the query can be executed as needed. Bob S > On Jul 28, 2017, at 06:24 , Trevor DeVore via use-livecode > wrote: > > On Wed, Jul 26, 2017 at 3:16 PM, Bob Sneidar via use-livecode < > use-livecode@

Re: Importing Unicode from MySQL

2017-07-28 Thread Trevor DeVore via use-livecode
On Wed, Jul 26, 2017 at 3:16 PM, Bob Sneidar via use-livecode < use-livecode@lists.runrev.com> wrote: > Trevor, does sqlYoga do this automatically? Is there a down side to doing > this by default? > SQL Yoga does not. I'm not familiar with the SET NAMES query so I don't know what the down sides a

Re: Importing Unicode from MySQL

2017-07-26 Thread Bob Sneidar via use-livecode
Trevor, does sqlYoga do this automatically? Is there a down side to doing this by default? Bob S > On Jul 26, 2017, at 08:47 , Devin Asay via use-livecode > wrote: > > Andy, > > Thanks for that tip. It’s one I never have heard about. I’ll try this next > time I need to read UTF8 from my db

Re: Importing Unicode from MySQL

2017-07-26 Thread Devin Asay via use-livecode
ative minimalist IDE Plugin for LiveCode TinyIDE Script editor Themer for LC http://2108.co.uk PointandSee is a FREE simple but full featured under cursor colour picker / finder. http://www.pointandsee.co.uk - made with LiveCode -- View this message in context: http://runtime-revolution.278305.n4.nabble

Re: Importing Unicode from MySQL

2017-07-26 Thread Kaveh Bazargan via use-livecode
er has bugs. It just develops random features. > > TinyIDE a Free alternative minimalist IDE Plugin for LiveCode > TinyIDE > > > Script editor Themer for LC http://2108.co.uk > > PointandSee is a FREE simple but full featured under cursor colour picker > / finder. > h

Re: Importing Unicode from MySQL

2017-07-26 Thread AndyP via use-livecode
-- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Importing-Unicode-from-MySQL-tp4717480p4717487.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-livecode mailing list use-livecode@lists.runrev.com

Re: Importing Unicode from MySQL

2017-07-25 Thread Kaveh Bazargan via use-livecode
Hi Devin Thanks for that. I just tried it and *Bodø River* becomes *Bod River* I was wondering at what point the Unicode is lost. So is it still intact when it is saved as a variable? and is it then lost when the variable is put into a field? By the way the BYU documentation is the best on Li

Re: Importing Unicode from MySQL

2017-07-25 Thread Devin Asay via use-livecode
Kaveh, The unicodeText property and uniEncode function are deprecated. Instead use textDecode as follows: Download your database data into a variable like tStringFromDatabase. Then, put textDecode(tStringFromDatabase,”UTF8”) into field “myDBText” HTH Devin On Jul 25, 2017, at 4:24 PM, Kaveh

Importing Unicode from MySQL

2017-07-25 Thread Kaveh Bazargan via use-livecode
I know this has been discussed before and I have tried to search for the answer, but no success. I am using LiveCode Community, 9.0.0 DP5 on Mac I have a MySQL database where all fields are formatted as UTF8. I do a query from LiveCode, and put the result in a field and I lose the non ascii chara