Re: varchar(5) and select question

Hi, 2006/6/29, Joerg Bruehe <[EMAIL PROTECTED]>: Hi Pooly, all, 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'); > > So, by mistake

Re: varchar(5) and select question

Hi Pooly, all, 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'); So, by mistake I inserted names which were too long for the field, but then I t

Re: varchar(5) and select question

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 i

varchar(5) and select question

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'); So, by mistake I inserted names which were too long for the field, but then I tried to do queries on this part