determining the character set of a table / database?

by

You can check the version using 

SELECT @@VERSION;

It it’s 9.00 or greater, you can check the collation of a column using 

SELECT collation_name FROM sys.columns 
WHERE name="column name"
AND [object_id] = OBJECT_ID('dbo.table name');

And for the database using

SELECT collation_name FROM sys.databases 
WHERE name="database name";

If it’s < 9.0 then you’re using SQL Server 2000 or lower. For 2000 I believe you can check similar columns (e.g. syscolumns.collationid for columns).

More Related Contents:

  1. Create a view with ORDER BY clause
  2. How to run the same query on all the databases on an instance?
  3. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  4. SQL Update with row_number()
  5. How to write UTF-8 characters using bulk insert in SQL Server?
  6. Is a single SQL Server statement atomic and consistent?
  7. When must we use NVARCHAR/NCHAR instead of VARCHAR/CHAR in SQL Server?
  8. Connecting to MS SQL Server with Windows Authentication using Python?
  9. SQL Server default character encoding
  10. How to query for Xml values and attributes from table in SQL Server?
  11. A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233)
  12. Should every User Table have a Clustered Index?
  13. cross apply xml query performs exponentially worse as xml document grows
  14. SQL Server Configuration Manager cannot be found
  15. Changing SQL Server collation to case insensitive from case sensitive?
  16. Compute MD5 hash of a UTF8 string
  17. SQL Query Where Column = ” returning Emoji characters 🎃 and 🍰
  18. Sql Server replication requires the actual server name to make a connection to the server
  19. Convert a string with ‘YYYYMMDDHHMMSS’ format to datetime
  20. Convert from DateTime to INT
  21. replace NULL values with latest non-NULL value in resultset series (SQL Server 2008 R2)
  22. SQL Server 2008 Spatial: find a point in polygon
  23. SQL Server – error when creating stored procedure
  24. SQL Server Escape an Underscore
  25. Does a foreign key automatically create an index?
  26. Why use the INCLUDE clause when creating an index?
  27. An attempt was made to access a socket in a way forbidden by its access permissions
  28. TSQL Try / Catch within Transaction or vice versa?
  29. Format SQL in SQL Server Management Studio
  30. Grant Select on a view not base table when base table is in a different database

Leave a Comment