I am using Oracle 9i as my database. My problem is the columns of the this database supplies an ample amount of white spaces.
For Example:
Username with Char(100) if I insert a 5 character inside this column like ADMIN it will have 95 white space after the word ADMIN.
The problem now is that every time I query I needed to use TRIM inside my query or else it will not work.
For example : SELECT COUNT(USERNAME) AS TOTAL FROM ASUSERACCOUNT WHERE TRIM(USERNAME) = :username
Are there any configurations I need to make to remove whitespaces on my database?