varchar and trailing spaces...

2005-09-03 Thread Jason Pyeron
I have found out that some files on the system, have trailing spaces... To make matters worse I have found 'file ' and 'file ' both exist, breaking constraint name. So am I better off going to TINYTEXT or VARBINARY(255) for the name field? That said another way, will TINTTEXT break the

Re: varchar and trailing spaces...

2005-09-03 Thread Paul DuBois
At 15:39 -0400 9/3/05, Jason Pyeron wrote: I have found out that some files on the system, have trailing spaces... To make matters worse I have found 'file ' and 'file ' both exist, breaking constraint name. So am I better off going to TINYTEXT or VARBINARY(255) for the name field?