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

Posted by Pradeepk under Sql Server on 11/22/2014 | Points: 10 | Views : 1041 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

Latest Posts