I created a table in my SQL2000, and when I had Enterprise Manager script the table generation for me, all the VARCHAR fields come out like this:
[quote] [username] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [/quote] I've never seen the "Collate" stuff before. What does that all mean? I know what "Username" means - that's the field name, and "Varchar" is the type of data stored, (15) is the length of the field, and "Not NULL" means it can't be empty, but what does all the rest mean? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
