| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Bob Kline | Date: | October 7 1999 12:15pm |
| Subject: | Re: Trailing blanks get chopped away from 'strings' | ||
| View as plain text | |||
On Thu, 7 Oct 1999, Tobias Brox wrote: > So it's a feature, not a bug? This can hardly be compliant with the SQL > standards? 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. -- Bob Kline mailto:bkline@stripped http://www.rksystems.com
| Thread | ||
|---|---|---|
| • Trailing blanks get chopped away from 'strings' | tobiasb | 6 Oct |
| • Re: Trailing blanks get chopped away from 'strings' | Faisal Nasim | 6 Oct |
| • Re: Trailing blanks get chopped away from 'strings' | Tobias Brox | 7 Oct |
| • Re: Trailing blanks get chopped away from 'strings' | Bob Kline | 7 Oct |
| • Re: Trailing blanks get chopped away from 'strings' | Tobias Brox | 7 Oct |
| • Re: Trailing blanks get chopped away from 'strings' | Michael Widenius | 7 Oct |
| • Re: Trailing blanks get chopped away from 'strings' | Faisal Nasim | 7 Oct |
| • Re: Trailing blanks get chopped away from 'strings' | Michael Widenius | 8 Oct |
| • Re: Trailing blanks get chopped away from 'strings' | Tonu Samuel | 8 Oct |
| • question on perl DBI _ListDBs function | James H. Thompson | 8 Oct |
| • Re: Trailing blanks get chopped away from 'strings' | Carsten H. Pedersen | 6 Oct |
| • Trailing blanks get chopped away from 'strings' | Jani Tolonen | 6 Oct |
| • Trailing blanks get chopped away from 'strings' | Jani Tolonen | 6 Oct |