Re: Oracle accent

Gints Plivna schreef:
boutreau.adrien@xxxxxxxxx wrote:
HI

I'm trying to insert into

ACC_REF VARCHAR2(20 BYTE),

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 ?

Thanks to read me!

The problem most probably is that your french characters take more
than one byte i.e. these are multibyte characters. You have to either

Assuming a multi byte character set is used. An assumption I would have
made, too, but I have had long discussions, based on wrong assumptions.

1) choose another characterset of the db so that your french
characters are not multi-byte (which actually means rebuild the DB,
actually just a theoretical solution ;)

Hmmm - there is a program called csscan (Character Set Scan), that will
show you whether you can switch from one charset to another.
So, this is not theoretical in all situations, but very likely (based
on earlier made assumptions) in this case.

2) change VARCHAR2(20 BYTE) to VARCHAR2(20 CHAR), so that oracle takes
more space for this particular column, but you definitely can store 20
characters not only 20 bytes.

Agree: that would be the "standard": change to character
semantics, instead of byte, for multi byte character sets.
Seems this is not the case here.

Gints Plivna
http://www.gplivna.eu



--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
.

Relevant Pages

  • ANN: vile 9.6
    ... Vile is a text editor which is extremely compatible with vi. ... buffer when closes, ... modify manfilt.c to provide UTF-8 output in a UTF-8 locale. ... winvile - multicolumn characters, depends on font selection ...
    (comp.editors)
  • 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: Modifying mergefield string contents
    ... > need to strip the first two characters and the last 5 characters from a ... an application where you can modify it before using it for mail merge. ... reply in the newsgroup and not by e-mail :-) ...
    (microsoft.public.word.mailmerge.fields)
  • Re: replacing text in JTextArea
    ... I searched java docs, this and others newsgroup, but I wasn't able to find out a replace function for input characters. ... What properties of JTextArea should I use to replace characters? ... In the AWT class, TextArea, if you press the Insert key it puts the TextArea into replace mode. ... If you want to modify the text that is entered into a JTextArea you need to create your own Document. ...
    (comp.lang.java.gui)
  • Re: need help deleting folders
    ... > Unknow folders and subfolders, not created by user, with wierd ... > names and characters have appeared on my OS. ... > modify them and inspite the fact that I have admin rights, ...
    (microsoft.public.win2000.general)