Maybe the company/shop have a standard that all character fields are varchar 
and the
developer was trying to follow the rules to keep their job. Maybe the specs 
dictated the
design. Maybe the original developer set it up to test out the new guy to see 
if they are
paying attention. It is quite possible the IT manager did not know any better 
when he set
it up this way. 

I've got many more, just ask. <bg>

Rick
White Light Computing, Inc.

www.whitelightcomputing.com
www.rickschummer.com
586.254.2530 - office
586.254.2539 - fax
  



-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Michael Babcock
Sent: Monday, August 14, 2006 03:07 PM
To: [EMAIL PROTECTED]
Subject: [NF] Varchar(1) ???

[SQL Server 2000]
Why would someone do a varchar(1).....it's no different in terms of space-saving
optimization that char(1), right?  Just found this to be odd.

-- 

Thanks,
--Michael



[excessive quoting removed by server]

_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to