Parameters, direct connectivity and strings that are too long

Parameters, direct connectivity and strings that are too long

Postby 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
upscene
 

Postby Ikar » Tue 10 Jan 2006 10:53

This is MySQL server behavior. Try to find solution in MySQL reference.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Postby upscene » Tue 10 Jan 2006 16:53

Right. It seems it is...

Bugger.


Thanks.
--
Martijn Tonies
Upscene Productions
upscene
 


Return to MySQL Data Access Components