Re: Character set: moving from WE8ISO8859P1 to UTF8
Date: Fri, 09 May 2008 09:20:38 +0200
> 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