Forums
This topic is locked
MS - SQL Field Types - Help
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
you need to use varchar.
Regards
Vince
Visit my home: www.chez-vince.com
VBScript | ASP | HTML | SQL | Oracle | Hosting