Re: Oracle accent

From: Thorsten Kettner <thorsten.kettner_at_web.de>
Date: 26 Apr 2007 01:11:36 -0700
Message-ID: <1177575096.598961.241970@s33g2000prh.googlegroups.com>

On 24 Apr., 11:04, boutreau.adr..._at_gmail.com wrote:
> this value : "0123456789012346éaé" (french accent) and i've got this
> error :
> 'ORA-01401: ' value is too big. I know the problem with oracle, and if
> I modify the number of byte the problem is resolved. But, is it
> possible to format the string before inserting into oracle and not
> modifying the number of byte ?

If you are looking for a way to remove special chars, try this:

select translate('aábcd', 'áàéè', 'aaee') from dual

However 'æ' would have to result in 'ae', right? For that you would need the replace function. And you would have one char more then the original string holds.

select replace('abcæ', 'æ', 'ae') from dual Received on Thu Apr 26 2007 - 03:11:36 CDT