Re: value too large why oh why?

From: prunoki <hegyvari_at_ardents.hu>
Date: 11 Feb 2007 04:06:55 -0800
Message-ID: <1171195615.523263.167550@p10g2000cwp.googlegroups.com>

Steve Howard írta:
> 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

Thanks, I was not aware of that. I guess I will be converting my varchars into nvarchars though, otherwise I cannot tell the user how long that box will be. Oracle set a nice little trap here.

K Received on Sun Feb 11 2007 - 06:06:55 CST