You are viewing limited content. For full access, please sign in.

Question

Question

insert value into database with column being a bit(1)

Workflow
Updated October 26, 2016
asked on October 26, 2016

We're trying to insert values into an existing database table and one of the columns in a bit(1).

When we execute the insert we get the following error:

Insert Data    ERROR [HY000] [MySQL][ODBC 5.3(w) Driver][mysqld-5.6.19-67.0-log]Data too long for column 'is_template' at row 1

 

Any ideas on how to insert a bit into a table? the value we're trying to insert is '0', so it's not an actual problem with the value not being representable by a bit(1).

 

0 0

Replies

replied on October 26, 2016

Workflow does not do any data conversions and it sounds like the driver treats it as a literal value too. You might have to try a custom query activity instead and MySQL's literal notation.

0 0
replied on October 26, 2016

Yea, that's basically the same solution we came up with as well. 

There was no need for the literal notation though, worked fine without it.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...