Home Forums Database Design Design Ideas and Questions Field Sizes in Staging database : all varchar(2000)? RE: Field Sizes in Staging database : all varchar(2000)?
Lokesh Vij
SSChampion
Points: 10836
More actions
July 19, 2012 at 11:21 am
#1515037
Short and simple answer:
If your flat file is fixed width (delimited) use CHAR data type else use VARCHAR
~ Lokesh Vij
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter