var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I know Microsoft SQLServer has UCS / Unicode support. However, I want to know how I check if a database supports Unicode or not.
Executing sp_helpsort will give you the colation. So you'd get an answer like:
Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive
How do I know if the DB supports unicode? Is it just a matter it does as long as the columns are defined as n*?
The following are unicode datatypes: nchar, nvarchar, ntext. You may also see string literals which is explicitly written as unicode, by addign a captital N immediately before the string:
And, if you should wonder what the N stands for... National. Nvarchar is an abbreviation for "National Varying Character".
declare @a nvarchar(10);
set @a = N'Demo';