MS SQL Server - nvarchar and varchar

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

nvarchar and varchar

cbrichards via SQLMonster.com

2006-04-03, 11:23 am

Why is it that some code is written using nvarchar and sometimes varchar. Is
it the collation order the database is using?

--
Message posted via http://www.webservertalk.com

Uri Dimant

2006-04-03, 11:23 am

I'd suggest to read about using these datatypes in the BOL

In short , if you want to store chines letters for example in the table
and properly dispaly them you have to define a column as NVARCHAR(n)

"cbrichards via webservertalk.com" <u3288@uwe> wrote in message
news:5e3a79b13cb4d@u
we...
> Why is it that some code is written using nvarchar and sometimes varchar.
> Is
> it the collation order the database is using?
>
> --
> Message posted via http://www.webservertalk.com

Sponsored Links