Re: Oracle accent

On 24 Apr., 11:04, boutreau.adr...@xxxxxxxxx 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

.

Relevant Pages

  • Re: Problem using FoxPro OLE DB Connection
    ... > It tests OK in the wizard, but refuses to work in ASP - although it ... > and my original string work in VBA. ... We had a similar problem with Oracle drivers above 9i, ... involved propagating permissions in the Oracle directory structure. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Binary String Transform
    ... If I do modify my input, then if will back to the same ... to the original string. ... above sequence to ... My Crypto code ...
    (comp.compression)
  • Re: File permission with datapump file (Oracle 10G Release2)
    ... The exported file permissions are set by default as shown below. ... Why would a user other than 'oracle' ... Modify the umask for the 'oracle' account. ... and in that script alter the permissions on the ...
    (comp.databases.oracle.server)
  • Re: Oracle accent
    ... I modify the number of byte the problem is resolved. ... possible to format the string before inserting into oracle and not ... The problem most probably is that your french characters take more ...
    (comp.databases.oracle.misc)
  • Re: 3rd-party function modifies a string passed by VALUE
    ... > Clipper 5 program is capable of modifying a parameter which (in Clipper ... to modify original string c/a needs its address. ...
    (comp.lang.clipper)