Re: Character set: moving from WE8ISO8859P1 to UTF8

From: Frank van Bortel <>
Date: Fri, 09 May 2008 09:20:38 +0200
Message-ID: <14dc0$4823fb47$524b5c40$>

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

Original text of this message