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
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
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
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
>
imalist 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.nabbl
tures.
>
> 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.
> http://www.pointandsee.co.uk - made
/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
Please visit this url to subscribe, uns
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
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,
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
10 matches
Mail list logo