nvarchar data type for all fields in the table.? [Resolved]

Posted by Pradeepk under Sql Server on 11/22/2014 | Points: 10 | Views : 369 | Status : [Member] | Replies : 1
I have a table that has many columns and they are of different data type.

I am assigning nvarchar for all the columns for ease of programming in future.

What problems could i face if i use nvarchar for all the fields in the Database.?

pradeep


Responses

Posted by: Bandi on: 11/24/2014 [Member] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
if you are using NVARCHAR for datetime column, the problems will come for sure in fture while fetching data. there are possibilities to enter incorrect data, different formats of dates and so on

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Pradeepk, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response