RE: Varchar mystery

2006-09-11 Thread Jerry Schwartz
: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, September 11, 2006 2:09 PM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: Varchar mystery Jerry Schwartz wrote: > I'm using MySQL Linux version 4.1.21 standard. > > I have a table with fields of a variety of types, includi

Re: Varchar mystery

2006-09-11 Thread Martijn Tonies
> I'm using MySQL Linux version 4.1.21 standard. > > I have a table with fields of a variety of types, including varchar(255) and > text (which might matter). When I do > > SELECT MAX(LENGTH(x)) FROM tx; > > where x is a varchar(255), I get back 266 as the result of the query! > > This isn't list

Re: Varchar mystery

2006-09-11 Thread Paul DuBois
Jerry Schwartz wrote: I'm using MySQL Linux version 4.1.21 standard. I have a table with fields of a variety of types, including varchar(255) and text (which might matter). When I do SELECT MAX(LENGTH(x)) FROM tx; where x is a varchar(255), I get back 266 as the result of the query! This

Varchar mystery

2006-09-11 Thread Jerry Schwartz
I'm using MySQL Linux version 4.1.21 standard. I have a table with fields of a variety of types, including varchar(255) and text (which might matter). When I do SELECT MAX(LENGTH(x)) FROM tx; where x is a varchar(255), I get back 266 as the result of the query! This isn't listed as one of