Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> UTF8 woes - ORA-01756 quoted strring not properly terminated

UTF8 woes - ORA-01756 quoted strring not properly terminated

From: Dirk Gomez <usenet_at_dirkgomez.de>
Date: 18 Feb 2003 20:42:27 +0100
Message-ID: <86k7fxe5p8.fsf@laptop.dirkgomez.de>


(Character Set: UTF8, Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production)

I'm having a weird umlaut/UTF8 problem.

Here's the statement that doesn't work:

SQL> insert into de_valid_blz values ('54861190' , 'Raiffeisenbank Oberhaardt-Gäu');
ERROR:
ORA-01756: quoted string not properly terminated

The second column is a VARCHAR2, so after some tries I ran this insert:

SQL> insert into de_valid_blz values ('54861190' , 'Raiffeisenbank SQL> Oberhaardt-Gäu ');
1 row created.

Strings like 'Raiffeisenbank Oberhaardt-Gäule' etc. work as well. So once I add more than one character after the umlaut things work fine.

Received on Tue Feb 18 2003 - 13:42:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US