Hello everyone,
is there any option in myDBR to right-trim CHAR data?
For instance, I have a report that I export in CSV and I see that a five-letter word stored in a CHAR(30) column is exported with 25 spaces on the right (this is just an example among many: I have lots of CHAR columns in my tables).
Considering the specificity of the CHAR type, this is not an un-explainable behavior but would there be a way to set up myDBR so that it always trims useless right spaces, so that I don't have to do it in the SQL of each of my queries (if I could change the data type of these columns in my database, I would, but I can't).
