The Collation feature (SLQ2K I think) is the way the server represents the data internally. I am sure its for ISO/Multilungual stuff and what you are getting is simple a default set by SQL Server (or you can set it yourself).
Neil -----Original Message----- From: Michael Kear [mailto:mkear@;afpwebworks.com] Sent: 12 November 2002 12:18 To: SQL Subject: What does this mean please? 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
