define custom collate sequence

Question

Is there a way to define a custom collate sequence for SQL Server 2005?

Answer 1

Yes there is but you need to be more specific. You can set the collation at many levels; server, db, table, column, query

---

Adam Tappis. (MCSD VB6 & .NET, MCDBA SQL 2000)

Answer 2

Hi bljstx,

Thank you for your post!

Like Adam said, there are several collation levels, I found some links in Books Online:

Collation Types
http://msdn.microsoft.com/en-us/library/ms175194.aspx

Using Server Collations
http://msdn.microsoft.com/en-us/library/ms144260.aspx

Setting and Changing Collations
http://msdn.microsoft.com/en-us/library/ms177439.aspx



Hope this helps! If you have any concern, please feel free to let me know.

---

ChunSong Feng
Microsoft Online Community Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.