Jan 26, 2007 #1 kk5 Technical User May 18, 2004 66 US how to know if the sql server 2000 installed is unicode or ANSI Thanks KK
Jan 26, 2007 #2 ptheriault IS-IT--Management Aug 28, 2006 2,699 US Right click on the database and select properties. You'll want to check the Server Collation. Here is a list of SQL Server Collations. Keep in mind that in SQL Server you can change the collation at the database or field level of a table. http://msdn2.microsoft.com/en-us/library/ms143508.aspx - Paul - If at first you don't succeed, find out if the loser gets anything. Upvote 0 Downvote
Right click on the database and select properties. You'll want to check the Server Collation. Here is a list of SQL Server Collations. Keep in mind that in SQL Server you can change the collation at the database or field level of a table. http://msdn2.microsoft.com/en-us/library/ms143508.aspx - Paul - If at first you don't succeed, find out if the loser gets anything.