MySQL dump 8.9 is doing weird things on me, I wonder what's going on. I have the following SQL column type : com_tel_fax_cr char(3), com_tel_fax_no varchar(8), the com_tel_fax_no is for storing an seven-digit phone number and the '-', ie: 727-1163 When the data is dumped, all char and varchar fields are writed with ' ', but not the com_tel_fax_no varchar. Here is what I get in the MySQL dump file : ... '800',727-1163, ... Notice that there is no ' around the phone number ? Worst, when I run MySQL dump in order to input sql from this file, it does the substraction (727-1163 = -436). I tried removing the - in the middle, didn't help, the field still comes out with no ' '. What puzzles me is that all other varchar and char fields get outputted right. Notice the '800' is the dump file. It does that with all phone number fields. This is stange. Anybody has any idea ? J. Lambert http://perl.xotechnologies.net --------------------------------------------------------------------- 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
