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
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@
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
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
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.
Devin
On Jul 26, 2017, at 1:03 AM, AndyP via use-livecode
mailto:use-livecode@lists.runrev.com>> wrote:
I had the same problems a while ago, but got it sorted with the follow
Hi Andy
That seems to work!! Boy what a journey. And thank you Devin for your help.
Regards
Kaveh
On 26 July 2017 at 08:03, AndyP via use-livecode <
use-livecode@lists.runrev.com> wrote:
> I had the same problems a while ago, but got it sorted with the following.
>
> *Before* you do any interac
I had the same problems a while ago, but got it sorted with the following.
*Before* you do any interactions with the db, add this line.
*revExecuteSQL MyConnectionID, "SET NAMES 'utf8'"*
"SET NAMES 'utf8'" is needed whenever you want to send/retrieve data
to/from the server having characters th
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
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
