Hi
I have recently shifted from using MySQL to PostgreSQL. I have a field in my
table which is of type char(10) .
When I do a getString() for this field using JDBC, I get a string of 10
characters even if the actual data is say 5 characters in length. The
remaining 5 characters are spaces.
This was not happening while using MySQL.
How can I get the actual data without spaces when I do a getString() without
having to add any kind of trimming code in the Java code.
regards
Sulaksana