Re: Storing a space

2004-05-02 Thread Remo Tex
Have you tried insertig non-breaking space instead #160 or 0xA0 ...i think so " " - this shoud be it /taken from here "3,02 KB (3 098 bytes)"-All NON-Breaking/ HTH ;-) John Mistler wrote: > Is there a way to force an invisible "space" character to be stored at the > END of a string in a column (e

Re: Storing a space

2004-04-30 Thread Paul DuBois
At 1:54 -0700 4/30/04, John Mistler wrote: Is there a way to force an invisible "space" character to be stored at the END of a string in a column (either VARCHAR or CHAR), so that when it is retrieved the space at the end is not cut off? No. I suggest that you use one of the TEXT types instead, wh

Re: Storing a space

2004-04-30 Thread Matt W
have a DEFAULT value; and 3) you can't index the whole column -- but you can INDEX (col(255)), which has the same effect. :-) Hope that helps. Matt - Original Message - From: "John Mistler" Sent: Friday, April 30, 2004 3:54 AM Subject: Storing a space > Is there a

Storing a space

2004-04-30 Thread John Mistler
Is there a way to force an invisible "space" character to be stored at the END of a string in a column (either VARCHAR or CHAR), so that when it is retrieved the space at the end is not cut off? theString + space or even, theString + space + space + space, etc. Currently, I can only get the str