| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> UTF8 woes - ORA-01756 quoted strring not properly terminated
(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.
![]() |
![]() |