In Oracle, you can use UTF-8 to store data to avoid conversion problem. Jacky ----- Original Message ----- From: "Eduardo San Martin B." <[EMAIL PROTECTED]> To: "Orion-Interest" <[EMAIL PROTECTED]> Sent: Tuesday, October 16, 2001 8:36 AM Subject: Re: Servlet JDBC character conversion problem
> Gustavo: > > I had a similar problem using PostgreSQL. I solved it changing my > database encoding to UNICODE, which is what Java uses for String > representation. > > Hope it solves your problem. Regards, > > Eduardo San Martín. > Concepción - Chile. > > > Gustavo Comba wrote: > > > Hi, > > > > I'm having a strange problem. I'm developing a J2EE Web > > Application, with Entity Beans, Servlets, JSPs and so on. I've > > started to get character conversion problems, and I've isolated > > the piece of code giving me problems. > > > > The code is: > > > > DriverManager.registerDriver(new > > oracle.jdbc.driver.OracleDriver()); > > Connection con = DriverManager.getConnection > > ("jdbc:oracle:thin:@oraclehost:1521:orcl", "user", "password"); > > dumpTable(con, out); > > String updateStatement = "UPDATE IDIOMAS SET IDIOMA = ? WHERE > > IDIDIOMA = ? "; > > PreparedStatement prepStmt = con.prepareStatement > > (updateStatement); > > prepStmt.setString(1, m_Idioma); > > prepStmt.setLong(2, m_Id); > > prepStmt.executeUpdate(); > > prepStmt.close(); > > con.close(); > > > > Where "m_Idioma", which is a standard java.lang.String, which > > eventually is "Español", and m_Id is a long with the primary key > > of the record I want to update. > > > > If I paste this code into a JSP, then I get the desired > > result, BUT, if I paste and run the code from a Servlet (exactly > > the same code), then my "Español" becomes "Espaýol"... I've > > tried almost everything, I've runned the Servlet on the J2EE > > server and locally whit the debugger, and the same result. > > > > My DataBase server is a Oracle 8.1.7 Database, and I'm using > > Oracle 9i Application Server OC4J (the Orion AS). > > > > The problem is the same with "á", "é", "í" and so on. > > > > I'll apreciate any kind of help you can give me. > > > > Thanks in advance, and please forgive my English. > > > > Gustavo Comba > > > > > > >