Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UTF8 woes - ORA-01756 quoted strring not properly terminated
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
Is the characterset on the machine you run SQL Plus on set to unicode? Looks like it's expecting another two-byte character and sees the u' as one unicode character.... strange problem.... wich version o Oracle are you using? Received on Tue Feb 18 2003 - 14:12:56 CST