Basically I am desiging a schema for datawarehouse in multi language support and iam setting up a suitable collation for this. But in some of the fields in different tables i am using nvarchar as a data type for some fileds where i need to insert different
language characters. But in some fileds i am thinking of using varchar where i am expecting just english language data.
My question is if i use varchar and nvarchar in the different fields on the same table in this database. Is there any performance issues ?
or just use nvarchar on all the fields where i am getting alphanumeric data.
What you people suggest.
Please tell me.
View Complete Post