Top "Nvarchar" questions

Determining Nvarchar length

I've read all about varchar versus nvarchar. But I didn't see an answer to what I think is a simple …

sql sql-server nvarchar

T-SQL: How to obtain the exact length of a string in characters?

I'm generating T-SQL SELECT statements for tables for which I have no data type information up-front. In these statements, I …

tsql string varchar nvarchar

How can Hibernate map the SQL data-type nvarchar(max)?

I have a column in my SQL-2005 database that used to be a varchar(max), but it has been changed …

sql-server-2005 hibernate varchar nvarchar

For Nvarchar(Max) I am only getting 4000 characters in TSQL?

This is for SS 2005. Why I am i only getting 4000 characters and not 8000? It truncates the string @SQL1 at 4000. ALTER …

sql sql-server sql-server-2005 tsql nvarchar

Nvarchar and text are incompatible in the add operator

With SQL Server 2008, I'd like to add a variable (@wfID) into a text, like below: DECLARE @wfID uniqueidentifier SET @wfID = …

sql sql-server-2008 guid nvarchar

Converting ntext to nvcharmax(max) - Getting around size limitation

I'm trying to change an existing SQL NText column to nvcharmax(max), and encountering an error on the size limit. …

sql nvarchar

How to convert TIMESTAMP values to VARCHAR in T-SQL as SSMS does?

I am trying to convert a TIMESTAMP field in a table to a string so that it can be printed …

sql-server tsql ssms nvarchar sql-timestamp

What size to pick for a (n)varchar column?

In a slightly heated discussion on TDWTF a question arose about the size of varchar columns in a DB. For …

database-design size varchar nvarchar

Converting Varchar to NVarchar?

I know when converting from nvarchar to varchar, some data will be lost/changed. However, are there any risks of …

sql sql-server-2008 varchar nvarchar sqldatatypes

Mapping to varchar and nvarchar in hibernate

If there are 2 columns in database, eg. code varchar(3) name nvarchar(50) How to tell hibernate to pass varchar for searching …

sql hibernate varchar nvarchar