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
srinivasarao
Messages: 15
Registered: April 2002
Junior Member
hello
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
like

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

try out with this
i hope you will get
regards
srinivasarao.pamidi
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 Mar 28 04:08:28 CDT 2024