Page 1 of 1

Parameters, direct connectivity and strings that are too long

Posted: Mon 09 Jan 2006 11:23
by upscene
Hi there,

I'm trying to insert some data using the Direct connectivity method (have not tried others).

I'm assigning a string of length 60 to a parameter for a column of length 20.

Instead of raising an error on INSERT, this actually runs fine and cuts the string down to a length of 20.

This is not what I want -- I want it to return an error!! How else would I know that my data is imported incorrect?

Any idea, comments?

--
Martijn Tonies
Upscene Productions

Posted: Tue 10 Jan 2006 10:53
by Ikar
This is MySQL server behavior. Try to find solution in MySQL reference.

Posted: Tue 10 Jan 2006 16:53
by upscene
Right. It seems it is...

Bugger.


Thanks.
--
Martijn Tonies
Upscene Productions