|
|
Posted by Dan Guzman on 10/01/06 17:21
All embedded white space characters are stored, just like the other
characters. The exception is that trailing spaces are removed from varchar
values when ANSI_PADDING OFF is specified (not recommended).
--
Hope this helps.
Dan Guzman
SQL Server MVP
"JA" <jarmour@kc.rr.com> wrote in message
news:F7STg.5346$3E2.1653@tornado.rdc-kc.rr.com...
>I think this may be a dumb question, but here goes.
>
> If there is a lot of "white space" in a field in SQL Server, does it take
> up server space, or is it just ignored?
>
> Example:
>
>
> Name of product<br>
>
>
> Manufacturer's Name<br>
>
>
> Manufacture's Phone number<br>
>
>
> Instead of this:
>
> Name of product<br>Manufacturer's Name<br>Manufacture's Phone
> number<br>
>
>
> I think it would, but maybe not?
>
> Thanks, J~
>
Navigation:
[Reply to this message]
|