List:General Discussion« Previous MessageNext Message »
From:Tobias Brox Date:October 7 1999 12:57pm
Subject:Re: Trailing blanks get chopped away from 'strings'
View as plain text  
> Please let us know which parts of the following passage from the manual
> are unclear, and how they could be improved:
> 
>    All string columns, except BLOB and TEXT columns, automatically have
>    all trailing spaces removed when retrieved.  For CHAR types this is
>    okay, and may be regarded as a feature according to ANSI SQL92.  The
>    bug is that in MySQL, VARCHAR columns are treated the same way.

So it is a bug :)

Sorry for not checking the manual before reporting it.

-- 
Tobias Brox (alias TobiX) - sysguy - +4722925871 - http://www.funcom.com/
If an _urgent_ email is not acted upon within 10 minutes, you might try
a _short_ mail to sms@stripped


Thread
Trailing blanks get chopped away from 'strings'tobiasb6 Oct
  • Re: Trailing blanks get chopped away from 'strings'Faisal Nasim6 Oct
    • Re: Trailing blanks get chopped away from 'strings'Tobias Brox7 Oct
      • Re: Trailing blanks get chopped away from 'strings'Bob Kline7 Oct
        • Re: Trailing blanks get chopped away from 'strings'Tobias Brox7 Oct
      • Re: Trailing blanks get chopped away from 'strings'Michael Widenius7 Oct
    • Re: Trailing blanks get chopped away from 'strings'Faisal Nasim7 Oct
      • Re: Trailing blanks get chopped away from 'strings'Michael Widenius8 Oct
    • Re: Trailing blanks get chopped away from 'strings'Tonu Samuel8 Oct
    • question on perl DBI _ListDBs functionJames H. Thompson8 Oct
  • Re: Trailing blanks get chopped away from 'strings'Carsten H. Pedersen6 Oct
  • Trailing blanks get chopped away from 'strings'Jani Tolonen6 Oct
    • Trailing blanks get chopped away from 'strings'Jani Tolonen6 Oct