Tuesday, November 12, 2002, 6:48:14 AM, Robertson-Ravo, Neil (REC) wrote: > 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).
That sounds correct. >From Books Online (BOL): "The physical storage of character strings in Microsoft� SQL Server� 2000 is controlled by collations. A collation specifies the bit patterns that represent each character and the rules by which characters are sorted and compared. SQL Server 2000 supports objects that have different collations being stored in a single database. Separate SQL Server 2000 collations can be specified down to the level of columns. Each column in a table can be assigned different collations. Earlier versions of SQL Server support only one collation for each instance of SQL Server. All databases and database objects created in an instance of SQL Server 7.0 or earlier have the same collation." For more about collations, look up "collations, overview" under SQL Server Architecture in BOL. -- Chris Montgomery monty @ airtightweb.com Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Get the mailserver that powers this list at http://www.coolfusion.com
