Re: TRIM and SUBSTR not working

From: Michael Krzepkowski <mkrzepkowski_at_hotmail.com>
Date: Thu, 10 Feb 2005 20:55:22 GMT
Message-ID: <_SPOd.356064$8l.278424@pd7tw1no>

Matthias Wirtz wrote:
> 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

Hi,

Look at the select you have used "trim(bla) o " (label!) vs what others run "trim(bla)"

However when you try
> select trim(bla) a,length(trim(bla)) from blabla

you should get correct results. Just the presentation of the column heading is incorrect.

HTH Michael Received on Thu Feb 10 2005 - 14:55:22 CST