I have to migrate an application from oracle to teradata DB.
This is a web application running on weblogic with spring+hibernate(with dialect from hibernate) with teradata last JBDC, using teradata vmware express edition.
Everything is up and running but when hibernate load into an string entity the value found in the db, it seems that load a series of spaces as much as field lenght specified in the db.
also when i access the data with SQLA and try to write in the proper column the string without space i notice that SQLA add spaces aribitrary. this is the result uotput that i get using the UI of SQLA when i set the value '100' in the column:
update "CONFIGURATION" set "VALUE_FIELD"='100' where "NAME"='TIMEOUT ...'
is that normal? i a matter of general db configuration?