SQL Data Conversion Question

microsoft.public.sqlserver.programming

19 Aug 2005 1:44 PM

Yosh

I have a column in a table that is a data type varchar. I am copying that data to another table's column that is nvarchar. The lengths are the same.

I understand the differences between the 2 types BUT do I need to explicitly convert the varchar to nvarchar data type?

Thanks,

Yosh

19 Aug 2005 2:16 PM

Alejandro Mesa

SQL Server will do it implicitly because nvarchar has higher precedence that
varchar. But doing it explicitly will not hurt.

AMB

Show quote

"Yosh" wrote:

> I have a column in a table that is a data type varchar. I am copying that data to another table's column that is nvarchar. The lengths are the same.
>
> I understand the differences between the 2 types BUT do I need to explicitly convert the varchar to nvarchar data type?
>
> Thanks,
>
> Yosh
>
>