Forums

This topic is locked

MS - SQL Field Types - Help

Posted 01 Aug 2003 01:00:52
1
has voted
01 Aug 2003 01:00:52 todd b. posted:
hello, everyone.

i'm having some trouble with the news section of my site. I am using 'char' for the main body, but it is filling the field with spaces if i do not match its maximum character specification.

what field type should i use for articles like this. Thanks in advance.

tmb

Edited by - vineire on 01 Aug 2003 01:01:40

Replies

Replied 01 Aug 2003 09:21:11
01 Aug 2003 09:21:11 Vince Baker replied:
char is a specified length field that will fill the unused characters with spaces.

you need to use varchar.

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting

Reply to this topic