[EMAIL PROTECTED] wrote: > > Hi! I'm working on resin+SAPDB+windows2000 now. > and when I use com.sap.dbtech.jdbc.DriverSapDB ,everything is > OK,but if > I use > com.sap.dbtech.jdbcext.ConnecttionPoolDataSourceSapDB, the > system can't > handle Chinese JSP page . > say if I insert a record into SAPDB, the Chinese word will become a > string "?????". > but I have set the database to UNICODE. > > BTW: is there any document to instruct the use of JDBC class ,say > Powertoys,jdbcext etc?
You should be aware of the fact, that setting the database to UNICODE does only mean, that 1. table-/column-/viewnames and so on will be stored with UCS/2, making asian tablenames and so on possible 2. that you are ALLOWED to specify that your character data will be stored in UCS/2, but it will NOT be stored in UCS/2 by default. If you want to store ALL character data in UCS/2, then set DEFAULT_CODE to UNICODE. If you just want to store some of your character data in UCS/2, then you have to specify CHAR (<integer>) UNICODE resp. VARCHAR (<integer>) UNICODE resp. LONG UNICODE for the corresponding columns. This is the minimum you have to do on server-side. If there are additional things to do on JDBC-side, another guy should tell you. Elke SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
