CODEWITHSUNDEEP
sql-serveroracle-databasesql-server-2005jdbc
ziggy
ziggy

Reputation: 15876

nvarchar & varchar with Oracle & SQLServer

I need to upload some data from an Oracle table to a SQL Server table. The data will be uploaded to the SQL server using a Java processing utilising JDBC facilities.

Is there any benefit in creating the SQL server columns using nvarchar instead of varchar?

Google suggests that nvarchar is used when UNICODE characters are involved but i am wondering does nvarchar provide any benefit in this situation? (i.e. when the source data of the SQL Server table comes from an Oracle database running a Unix environment?)

Thanks in advance

Upvotes: 3

Views: 3465

Answers (1)

Andrew
Andrew

Reputation: 27294

As you have found out, nvarchar stores unicode characters - the same as nvarchar2 within Oracle. It comes down to whether your source data is unicode - or whether you anticipate having to store unicode values in future (e.g. internationalized software)

Upvotes: 3

Related Questions