Re: value too large why oh why?

From: Steve Howard <stevedhoward_at_gmail.com>
Date: 10 Feb 2007 12:13:00 -0800
Message-ID: <1171138380.663072.251410@h3g2000cwc.googlegroups.com>

On Feb 10, 1:41 pm, "prunoki" <hegyv..._at_ardents.hu> wrote:
> I found out that every national character counts as two against the
> permitted length and substr is not aware of that. After converting the
> data type to nvarchar2(50) it works. This is something I am not used
> to as I can usually pick the database charset (XE did not let this for
> me). What is going to byte me next when using XE?
>
> Cheers.
>
> Krisztian

Hi,

Try substrb()

HTH, Steve Received on Sat Feb 10 2007 - 14:13:00 CST