How to handle fixed size char datatype of SQL in .net

Question

I am sure you would have faced and solved it in your way, So I am requesting you to reveal a good way to handle the mentioned problem in .net.
When we use fixed size data-type like Char(5) in SQL and store less characters, while accessing it put blank spaces also. How to handle it?
Please don't suggest me to use only required no of chars in DB. I have a valid reason/requirement for future enhancement.

Muralidharan Deenathayalan · Answer

Instead of char(5)you can use varchar(5). If you use varchar(5) if the number of characters are less than 5 it will not put any empty spaces in it. Suppose  if you are restricted to use only char(5). while fetching the data  you have to use trim function to remove the unwanted space in it. But the better approach is use varchar instead of char datatype.

Muralidharan Deenathayalan · Answer

I don't think any think for this. The best approach is use varchar instead of char datatype. Because if you use trim function  it is another overhead because in all the SPsviews you may have to implement the trim functions.

Anil Kumar · Answer

So for I got two views 1) use of varchar instead of char and 2) using trim( at present I use this). Is there are other techniques also?

Jiteendra Sampathirao · Answer

Hi Using varchar is always the best option. when you retrieve from database use the built-in functions to get the required shape of the value. And one more choice is do the validations in UI page when you enter the values into database. Mark it as Answer if any forum post is helped you...correct answer might help others..