Home » Non-English Forums » Japanese » Inserting Japanese data into Oracle via VB
Inserting Japanese data into Oracle via VB [message #66352] Wed, 24 April 2002 03:44 Go to next message
Bhavin Parikh
Messages: 1
Registered: April 2002
Junior Member
While trying to insert Japanese data via VB 6.0 frontend (using Microsoft ODBC for Oracle) to the Oracle 8i backend, the following error Ora-01756 (quoted string not terminated properly) occurs.
Please suggest a suitable solution to solve this problem.
Re: Inserting Japanese data into Oracle via VB [message #66354 is a reply to message #66352] Wed, 24 April 2002 20:11 Go to previous message
Messages: 15
Registered: April 2002
Junior Member
i think it is not the problem of language of japanese
what you had given error is purely oracle error
wht you sent insert data to oracle has with lack of quoted strings like

insert into emp(empno,ename)values(1234,'sri);
insert into emp(empno,ename)values(1234,sri');

in vb it should be pass through properly by using
quoted strings

connection.execute("insert into emp(empno,ename)values(" & 1234 & ",'" & sri& "'");

try out with this
i hope you will get
Previous Topic: how to change the database language to JAPANESE
Next Topic: JSP / JDBC Problem Japanese Char - Urget Pelase please
Goto Forum:

Current Time: Thu Dec 14 07:58:43 CST 2017

Total time taken to generate the page: 0.02185 seconds