Oracle Update Column LTRIM and RTRIM

Hi there,

I am wish to update my database data in SQL Developer using

“UPDATE TABLE_NAME SET COLUMN_NAME = LTRIM(RTRIM(COLUMN_NAME))”.

But it does not take any effect even the msg of “rows updated” is displayed. The leading and trailing white spaces still exist behind every strings.

Any ideas? :confused:

maybe they’re not spaces but rather some other unprintable character