Re: Issues while storing a long dash in oracle

From: Sandy80 <>
Date: Tue, 11 Mar 2008 01:24:11 -0700 (PDT)
Message-ID: <>

But my problem is that even if that character is processed and stored correctly in the database it would still be stored as a 2 byte character. In that case how do I make the following command, which works on the basis of no. of bytes, work correctly:

nvl(rpad(UPPER(substr(nvl( substr(column1,1,instr(column1,'(')-1),column1),

1,24)),24),'                        ')
Received on Tue Mar 11 2008 - 03:24:11 CDT

Original text of this message