MySQL insert query problem

Lol McBride newspost at lolmc.com
Mon Jan 26 19:56:03 CET 2004


On Sun, 25 Jan 2004 17:49:37 -0500, Mike C. Fletcher wrote:

> Did you by any chance declare the field to be 19 characters wide when 
> creating the database?  Truncating to the length of the field is, I 
> think, normal SQL practise.
> 
> Just a thought,
> Mike
> 
> Lol McBride wrote:
> ...
> 
>>varchar field in a database I'm using. The query being sent to the MySQL
>>server  by my program is : INSERT INTO analysis (DrawNumber,pool1)VALUES
>>(847, ' (4, 8, 21, 24, 39, 44) ' ) ;
>>
>>But the field pool1 actually contains  (4, 8, 21, 24, 39, i.e it is
>>missing the final digits ( 44 ) 
>>
> ...
> 
> _______________________________________
>   Mike C. Fletcher
>   Designer, VR Plumber, Coder
>   http://members.rogers.com/mcfletch/
Oh yeah baby, obvious and therefore invisible to my gaze.Thank you for
opening my eyes.
Lol McBride



More information about the Python-list mailing list