[OT] Problem with MySQL Insert

[Paul Foraker]

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