Anil Kumar

Anil Kumar

  • 192
  • 10.9k
  • 1.3m

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

May 30 2011 10:48 AM
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.

Brought to you by: JavaScript SDK for Bold BI dashboard and analytics embedding. Free trial.

Answers (4)