Re: TRIM and SUBSTR not working

Anurag Varma wrote:

> I think this has to do with the database characterset.
> If its a single byte .. you see the latter behavior.
> If its multibyte .. then you see the former behavior.

Both databases have the same character sets:

stat_at_STAT2> select * from v$nls_parameters where parameter LIKE 'NLS%_CHARACTERSET';

PARAMETER                  VALUE
-------------------------- -------------
NLS_CHARACTERSET           WE8ISO8859P1
NLS_NCHAR_CHARACTERSET     AL16UTF16

--
Matthias Wirtz - Norfolk, usa