> I have a problem with unicode ( JDBC driver): [...] I tried to reproduce the error (see attachment), but it seems to work here. Please run the program at your site after changing user name etc.
If it seems to work, change the program to match the situation where the error occurs. If the select fails, the JDBC trace (http://sapdb.2scale.net/moin.cgi/JdbcTrace) and the database trace (http://sapdb.2scale.net/moin.cgi/knldiag) would be useful. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ > -----Original Message----- > From: srinivas vanapalli [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 30, 2001 2:42 PM > To: [EMAIL PROTECTED] > Subject: problem with UNiCODE and JDBC (urgent) > > > hi all, > > I have a problem with unicode ( JDBC driver): > > 1. I created a table using sql Studio 7.3.1 > > CREATE TABLE TEST > ( > "ID" Integer NOT NULL, > "NAME" Varchar (500) UNICODE NOT NULL, > "PASSWORD" Varchar (500) UNICODE NOT NULL > ) > > 2. I inserted a record using JDBC 7.3.019a > insert into TEST (ID,NAME,PASSWORD) values(1,'test','test') > > 3. I selected the record using JDBC > select * from TEST where NAME='test' > > I could not retrieve the record but if I insert it using SQL > studio then I > could retrieve the record from JDBC and SQL studio. > > > thank you in advance, > > srinivas > > >
UnicodeSelect.java
Description: Binary data
