Parameters, direct connectivity and strings that are too long

upscene · Post by **upscene** » Mon 09 Jan 2006 11:23

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

Ikar · Post by **Ikar** » Tue 10 Jan 2006 10:53

This is MySQL server behavior. Try to find solution in MySQL reference.

upscene · Post by **upscene** » Tue 10 Jan 2006 16:53

Right. It seems it is...

Bugger.

Thanks.
--
Martijn Tonies
Upscene Productions