[OT] Problem with MySQL Insert

[Peter Haworth]

As Mark said, it's hard to believe mySQL is doing this. The other element
is Sequel Pro - not likely but maybe it's doing the time conversion?

Have you tried selecting the data with Livecode (revDataFromQuery)?

On Wed, Mar 25, 2015, 7:18 AM Paul Foraker <paul at whitefeather.com> wrote:

> Thanks, Mark.
>
> On Wed, Mar 25, 2015 at 1:27 AM, Mark Schonewille <
> m.schonewille at economy-x-talk.com> wrote:
>
> > Can you confirm that the MySQL syntax you see in the message box is the
> > same as what you entered in Sequel Pro?
> >
>
> In Sequel Pro, I wrapped the time period in double quotes.
>
> When we tried that in LiveCode, it posted the quotes to the field, and the
> times were still adjusted.
>
> (I mistyped the 10... it's set at 20).
>
>
> >
> > What are the collations of the database and the time field?
> >
>
> Sequel Pro is displaying 'latin1_swedish_ci' as the default for the VARCHAR
> fields.
>
> --
>
> White Feather Software
> www.whitefeather.com
> Cell: 408-391-1480
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>