Hi, the JDBC-driver supports unicode inside sql-commands, username and password only if you set the connect propertie "unicode=yes" (!!! not unicode=true). Details about connect properties can you find at: http://www.sapdb.org/jdbcSapdbcEng.html. If you plan to use unicode inside the password please use the newest JDBC-driver available at ftp://ftp.sap.com/pub/sapdb/bin/patch/sapdb-jdbc-bin-7.3.0.21a.jar.
Regards Marco ---------------------------------------------- Marco PASKAMP SAP DB, SAP Labs Berlin > -----Original Message----- > From: Dmitry Bukeev [mailto:[EMAIL PROTECTED]] > Sent: Mittwoch, 16. Januar 2002 11:21 > To: SAPDB - GENERAL > Subject: SAPDB & JDBC & National CharacterSet > > > Hi all, I have some question. JDBC driver couldn't correct > transfer string > with national characters to SAPDB when I use Statement.execute(). Same > problem with using DbVisualizer. Please, help me. > > Problem description > -------------------------------------------- > Statement stmt; > .... > .... > stmt.execute ("Create table UnicodeTest (" > + "ucol char (20) unicode," > + "ucol2 char (20) unicode," > + "ulongcol LONG UNICODE)"); > .... > .... > stmt.execute("insert into UnicodeTest (ucol, ulongcol) values > ('SOMESTRING','@@@@')"); > ResultSet cursor = stmt.executeQuery("select ucol, ulongcol from > UnicodeTest"); > while (cursor.next ()) { > for (int i = 1; i <= 2; ++i) { > String fetchValue = cursor.getString (i); > System.out.println ("cursor.getString (" + i + "): > '" + fetchValue > + "'"); file://#print > } > } > ------------------------------------- > When 'SOMESTRING' is string in Latin-1 codepage, that's all right. > But when i insert instead of 'SOMESTRING' string with > national codepage as > russian Windows-1251, i have trouble. > select return string as '???????'. > For PrepareStatement it is OK. > ------------------------------------------------- > I use SAPDB 7.3.0 , JDBC driver 7.3.0-0.19a, JDK 1.3.1 on Windows 2000 > Professional with Russian locale. > Dbase for testing I was create with unicode support with next > parameters : > param_put _UNICODE YES > param_put DEFAULT_CODE UNICODE > I test JDBC with and without parameter unicode=true. > > Dmitry Bukeev >
