Unicode data storing in SQ Server

[Seshadri]

When we update a unicode value in SQL Server database that
has datatype as nvarchar, we use the prefix "N" before the
unicode data and it stores the data in the respective
language. Is this the correct way to store unicode value
in SQL Server database? In ORACLE, the unicode value is
stored as numbers in the table. Why in SQL Server it is
not stored as numbers and stores in the respective
language itself?

Thanks
Seshadri

 

[Cor]

Hi Seshadri,

Here we do a lot and probably you get an answer here, but I think this
question is more for a SQL newsgroup or maybe for the active Ado.Net
newsgroup .

microsoft.public.dotnet.framework.adonet

Just a thought?

Cor

 

[Herfried K. Wagner [MVP]]

When we update a unicode value in SQL Server database that
has datatype as nvarchar, we use the prefix "N" before the

ADO.NET group:

<
Web interface:

<http://msdn.microsoft.com/newsgroup...roup=microsoft.public.dotnet.framework.adonet>