Re: Character set: moving from WE8ISO8859P1 to UTF8
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 09 May 2008 09:20:38 +0200
Message-ID: <14dc0$4823fb47$524b5c40$32132@cache2.tilbu1.nb.home.nl>
Date: Fri, 09 May 2008 09:20:38 +0200
Message-ID: <14dc0$4823fb47$524b5c40$32132@cache2.tilbu1.nb.home.nl>
jeremy wrote:
>
> We already ran across something strange where use of
>
> substr(myvar,1,4000) resulted in a pl/sql numeric or value error as
> the number of chars returned (or do I mean bytes?) was actually 4001 -
> and we were trying to populate a pl/sql variable defined as
> varchar2(4000)... the developer then looked at substrb but I think
> that this is not the correct answer (though I could be wrong).
Realize that those symptoms will cascase through all of your application! Suddenly, columns aren't wide enough, PL/SQL will break, etc, etc.
BTDT - FvB Received on Fri May 09 2008 - 02:20:38 CDT