prunoki wrote:
> 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
There is also an INSTRB too.
http://www.psoug.org/reference/string_func.html#sisb
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Feb 11 2007 - 12:26:29 CST
