Jeff, Thursday, October 10, 2002, 5:44:28 PM, you wrote: JZ> I have a MySQL 40 column table where I select an entire row then insert JZ> it into another (different) 40 column table. For some reason the insert JZ> fails and after much troubleshooting I've isolated the cause to a field JZ> heading labeled prod_num. This field is a type varchar(10) and it's JZ> value is 1090C. If I set the value to 1090 it works ok. I've also JZ> tried TINYTEXT same problem. If I use the value 1090C in other fields JZ> works ok so problem seems to be related to field labeled prod_num. JZ> Another mystery, if I reset the value in my script to 1090C after the JZ> select the insert also works OK. I have checked to make sure there are JZ> no new line returns and just don't know what else to try.
Jeff, I created, inserted, selected data from column 'prod_name' without any problems. So, could you provide structure of your table, failed INSERT statement? What version of MySQL server you are using? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php