Re: UTF8 woes - ORA-01756 quoted strring not properly terminated

From: NoResult <dj_noresult_at_hotmail.com>
Date: 18 Feb 2003 20:14:02 GMT
Message-ID: <Xns9326D75092B44djnoresult@194.109.133.20>

Dirk Gomez <usenet_at_dirkgomez.de> wrote in news:86k7fxe5p8.fsf_at_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.
>
> -- Dirk

sorry for the version question.... missed your first line :-) Received on Tue Feb 18 2003 - 14:14:02 CST