On Thursday 29 June 2006 08:18 am, Pooly wrote: > Hi, > > I stumbled on one issue yesterday which took me some time to figure out. > the table is : > create table tt ( PCname varchar(5) not null default ''); > insert into tt values ('Centaure');
(5) indicates a display width. > So, by mistake I inserted names which were too long for the field, but > then I tried to do queries on this particular value : > Select * from tt WHERE PCname='Centaure'; > which returns obviously no result. How comes the 'Centaure' in the > SELECT is not cut has it is in the INSERT ? SELECT probably doesn't care about the display width with regards to WHERE clauses, it just wants to see if the field matches and be done with it. The real answer to your issue would be to increase the display width, possibly through ALTER TABLE. > -- > http://www.w-fenec.org/ -- Chris White PHP Programmer/DBlame Me Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]