Top "Nvarchar" questions

What is the difference between varchar and nvarchar?

Is it just that nvarchar supports multibyte characters? If that is the case, is there really any point, other than …

sql-server varchar nvarchar

What are the main performance differences between varchar and nvarchar SQL Server data types?

I'm working on a database for a small web app at my school using SQL Server 2005. I see a couple …

sql-server sql-server-2005 storage varchar nvarchar

nvarchar(max) vs NText

What are the advantages and disadvantages of using the nvarchar(max) vs. NText data types in SQL Server? I don't …

sql-server sql-server-2005 sql-server-2008 text nvarchar

Convert NVARCHAR to DATETIME in SQL Server 2008

In my table LoginDate 2013-08-29 13:55:48 The loginDate column's datatype is nvarchar(150) I want to convert the logindate column into …

sql datetime sql-server-2008-r2 nvarchar

When must we use NVARCHAR/NCHAR instead of VARCHAR/CHAR in SQL Server?

Is there a rule when we must use the Unicode types? I have seen that most of the European languages (…

sql-server unicode collation nvarchar

Convert nvarchar to bigint in Sql server 2008

I want insert all rows of a table into another table, and I also want convert a nvarchar field into …

sql sql-server-2008 nvarchar bigint

How to create NVarchar(max) Sqlparameter in C#?

I've got the following code to pull back a DataTable using a stored procedure and inputting a string parameter @JobNumbers, …

c# sql nvarchar sqlparameter

Difference between NVARCHAR in Oracle and SQL Server?

We are migrating some data from sql server to oracle. For columns defined as NVARCHAR in SQL server we started …

sql-server database oracle nvarchar varchar2

SQL Server 2008: Error converting data type nvarchar to float

Presently troubleshooting a problem where running this SQL query: UPDATE tblBenchmarkData SET OriginalValue = DataValue, OriginalUnitID = DataUnitID, DataValue = CAST(DataValue AS …

sql-server-2008 casting floating-point nvarchar

Convert nvarchar to int in order to join SQL tables in a view

I want to create a view which will display the info from two tables joined by different type fields. The …

sql int inner-join nvarchar sql-view