0

Char values in update/insert query seems to be trimmed

Hi,

It seems that when I do an update of a char data type in nuoDB the new value's been trimmed. Is there any way that it doesn't do that, I need the blank spaces in the end.

SQL> update table_test set test_column = '1111     '  ;

SQL> select length(test_column) as length, test_column, '|' || test_column || '|' as test_column from table_test ;

LENGTH TEST_COLUMN TEST_COLUMN
-------       ------------             ------------
4            1111                  |1111|

1 comment

Please sign in to leave a comment.