Home » RDBMS Server » Server Administration » Tomcat Oracle 8i utf8
Tomcat Oracle 8i utf8 [message #51957] Mon, 24 June 2002 01:59 Go to next message
crystal
Messages: 5
Registered: August 2001
Junior Member
Dear experts,

I am using tomcat 4.0 with oracle 8i(utf8).

Using sqlplus to insert data into the db result in 3 or 4 bytes each for chinese character. However using tomcat with JSP, it founds to be 8 bytes for each character. Chinese characters can update and retrieve correctly through the tomcat. However those characters are seen as numbers in the sqplus.

Thank!
Re: Tomcat Oracle 8i utf8 [message #51958 is a reply to message #51957] Mon, 24 June 2002 02:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you change the configuration of Tomcat so that
it uses the Oracle JSP Engine instead of the default JSP Engine
supplied with Tomcat and to then set the initialisation
parameters accordingly to allow translation of the Parameter Information?.
I beleive by modifying the global web.xml file shall help you.
Re: Tomcat Oracle 8i utf8 [message #51984 is a reply to message #51957] Mon, 24 June 2002 20:50 Go to previous messageGo to next message
crystal
Messages: 5
Registered: August 2001
Junior Member
Dear Mahesh Rajendran
I have open the global web.xml and have no idea to set which parameters.

Would you like to give some more help!

Thank!
Re: Tomcat Oracle 8i utf8 [message #51999 is a reply to message #51957] Tue, 25 June 2002 10:35 Go to previous message
Andrew
Messages: 144
Registered: March 1999
Senior Member
This is normal behavior for SQL*Plus. SQL*Plus cannot support multiple character sets. However, the data is stored in the database just fine.

Andrew
Previous Topic: ora-27500
Next Topic: Re: ocp
Goto Forum:
  


Current Time: Wed Dec 25 22:07:07 CST 2024