Top "Nvarchar" questions

SQL performance: Is there any performance hit using NVarchar(MAX) instead of NVarChar(200)

I am wondering if there is any disadvantage on defining a column of type nvarchar(max) instead of giving it …

sql-server performance indexing nvarchar

Syntax for linq query to List<string>

I am trying to do something like this... public static List<string> GetAttachmentKeyList() { DataClassesDataContext dc = new DataClassesDataContext(); List&…

string linq casting nvarchar

Special characters displaying incorrectly after BULK INSERT

I'm using BULK INSERT to import a CSV file. One of the columns in the CSV file contains some values …

sql sql-server-2012 bulkinsert nvarchar

What's the SQL national character (NCHAR) datatype really for?

As well as CHAR (CHARACTER) and VARCHAR (CHARACTER VARYING), SQL offers an NCHAR (NATIONAL CHARACTER) and NVARCHAR (NATIONAL CHARACTER VARYING) …

sql sql-server oracle tsql nvarchar

Oracle Text will not work with NVARCHAR2. What else might be unavailable?

We are going to migrate an application to have it support Unicode and have to choose between unicode character set …

oracle unicode character-encoding nvarchar

Are there disadvantages to using VARCHAR(MAX) in a table?

Here is my predicament. Basically, I need a column in a table to hold up an unknown length of characters. …

sql-server varchar nvarchar

Inserting special characters (greater/less than or equal symbol) into SQL Server database

I am trying to insert ≤ and ≥ into a symbol table where the column is of type nvarchar. Is this possible …

sql-server unicode nvarchar

How does SQL Server store more than 4000 characters in NVARCHAR(max)?

I have defined a stored procedure that has a parameter of type NVARCHAR(max) and I process that string in …

sql-server stored-procedures nvarchar

Inserting national characters into an oracle NCHAR or NVARCHAR column does not work

When inserting strings in an oracle database, some national characters are replaced with question marks, even though they are inserted …

java oracle unicode sqlplus nvarchar

Sql Server - Index on nvarchar field

What is the good approach to keep a nvarchar field unique. I have a field which is storing URLs of …

sql sql-server nvarchar