This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Has anyone else encountered this? If so, what approach have you taken?
Yup. And here's what I did: I kept the database format, that is, I didn't use null terminators, I used empty spaces to fill the remaining positions of each field value. For instance, if a field length in the database is 64 positions, and the provided value has 50 characters, then it will be saved with the 50 characters + (64 - 50) empty spaces.