Top "Nvarchar" questions

What is the point of COLLATIONS for nvarchar (Unicode) columns?

IVe read a lot about this. Still some questions : Im not talking about case sensitive here... If I have a …

sql-server sql-server-2008 unicode collation nvarchar

Error converting data type nvarchar to bigint caused by IN operator in Stored Procedure

Stored Proc: ALTER PROCEDURE [dbo].[MyProcedure] @CommaSeperatedValues nvarchar(500) AS BEGIN SET NOCOUNT ON; SELECT Col1, Col2, Col3 FROM MyTable WHERE …

sql-server stored-procedures nvarchar in-operator

nvarchar concatenation / index / nvarchar(max) inexplicable behavior

I today ran into a really weird problem in SQL Server (both 2008R2 and 2012). I'm trying to build up a …

sql-server sql-server-2012 string-concatenation nvarchar

Limiting NVARCHAR size in SQLServer?

I was wondering what would be the consequences of setting NVARCHAR fields to MAX instead of a specific size in …

sql-server nvarchar

Calculating SHA1 hash of a 'nvarchar' string using T-SQL

I'm trying to calculate SHA1 hash of a unicode string using T-SQL. The below code works fine with ASCII strings: …

tsql hash nvarchar

Hibernate with NVARCHAR2

I have table with a column as NVARCHAR2, and I have build my object with hibernate annotations, When i want …

hibernate oracle11g hibernate-mapping nvarchar