DBExpress - Auto Trim Char Fields (Using SQL Server)
Posted on 2012-08-29
There was an option to auto trim chars fields using dbexpress connection?
The parameter "Trim Char" or "TrimFixedChar" isn't avaiable while using SQL Server drivers.
Do you guys knows if there is any way to do that?
If not possible on the connection, is there any way to do that directly on the clientdataset? Inheriting a method? (I already use a custom ClientDataSet, but, I haven't found a method that I can perform a trim while reading records)
I suppose you guys will tell me to change char fields to varchar, but, at this moment, It's impossible to change all my database datatypes to varchar (It has almost 13 years and has more than 150gb).