Top "Nvarchar" questions

What is the performance penalty of XML data type in SQL Server when compared to NVARCHAR(MAX)?

I have a database that is going to keep log entries. One of the columns in the log table contains …

sql-server xml tsql nvarchar

What is the biggest data type to use as a local variable in a stored procedure?

I have the next issue: --DECLARE @TEST NVARCHAR(MAX) --DECLARE @TEST2 NVARCHAR(MAX) DECLARE @TEST NTEXT DECLARE @TEST2 NTEXT NVARCHAR(…

sql-server text asp-classic procedure nvarchar

The data types ntext and nvarchar are incompatible in the equal to operator

I have a problem and i dont know how to fix it. I have a simple table in database CREATE …

c# asp.net sql nvarchar ntext

nVarchar and SqlParameter

I'm developing an application which must support several languages. To solve the special characters problem I'm using NVarhcar for my …

c# nvarchar sqlparameter

Should I be using JDBC getNString() instead of getString()?

We are building a Java application backed by an Oracle database that we access using JDBC (drivers ojdbc6.jar and …

java oracle jdbc nvarchar

Is VARCHAR like totally 1990s?

VARCHAR does not store Unicode characters. NVARCHAR does store Unicode characters. Today's applications should always be Unicode compatible. NVARCHAR takes …

sql-server nvarchar

unique column of type nvarchar

I have a simple table: File: path | deleted | categories | description I want to use the table for a Linq to …

sql sql-server linq-to-sql unique nvarchar

NVARCHAR(?) for Email addresses in SQL Server

For Email addresses, how much space should I give the columns in SQL Server. I found this definition on Wikipedia: …

sql sql-server email sql-server-2008-r2 nvarchar

Using indexes with NVarchar(50) vs. NVarchar(255) column?

We have an indexed column (ModelName) which has a big importance in the table and is very similar to a "…

sql-server sql-server-2005 indexing nvarchar

What is the maximum size we can give for nvarchar in sqlite?

In SqlServer we can use NVarchar(MAX) but this is not possible in sqlite. What is the maximum size I …

sqlite nvarchar max-size