MySQL insert query problem

Mike C. Fletcher mcfletch at rogers.com
Sun Jan 25 23:49:37 CET 2004


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/






More information about the Python-list mailing list