| Inserting Japanese data into Oracle via VB [message #66352] |
Wed, 24 April 2002 03:44  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
