List:General Discussion« Previous MessageNext Message »
From:Faisal Nasim Date:October 6 1999 8:34am
Subject:Re: Trailing blanks get chopped away from 'strings'
View as plain text  
: >Description:
: I have some strings ending with blank characters. They are
: efficiently removed. The trailing blanks are relevant.

According to the doc:

CHAR(M) [binary]  A fixed length string that is always filled up with spaces
to the specified length. Range 1 - 255 characters. All end space are removed
when retrieved. Is sorted and compared case insensitively unless the binary
keyword is given.  M

VARCHAR(M) [binary]  A variable length string that is stored with its
length. All end space are removed when storing it. Maximum range 1 - 255
characters. Is sorted and compared case insensitively unless the binary
keyword is given.


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