thanks. i tried converting data but nothing works, maybe i should try UTF-7 and see.. but can u send me examples ...
-----Original Message----- From: Jason Lea [mailto:[EMAIL PROTECTED] Sent: Friday, October 29, 2004 5:29 PM To: Struts Users Mailing List Subject: Re: Internationalization of characters --UTF8 encoding Shilpa Nalgonda wrote: >Hi, > >I am using Tomcat4.1, Oracle 8i , and XmlRpc to write an application which >is supposed to take japanese characters an insert them into database. Is >there any setting in Tomcat4 where i should be giving the encoding option. >And aslo i get the request from the client in the form of xml and pass that >request via xmlrpc and insert into oracle database. >The client sends japanese characters in Unicode , our database has caracter >set of US7ASCII. > >select * from NLS_DATABASE_PARAMETERS where parameter = 'NLS_CHARACTERSET'; > >PARAMETER VALUE >------------------------------ ------------------------------ >NLS_CHARACTERSET US7ASCII > >The data is being inserted as all brackets in database.'{{{' >Is there any conversion i need to do while inserting in the database. > >Please suggest if anyone has any opinions. > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > > > If you can't change the database to Unicode/UTF-8 encoding then you would have to convert strings going into and coming out of the database. This would be the best option for reading/writing the database. Everything else takes a lot of extra work. You maybe able to dump the database and recreate a new one as Unicode/UTF-8 and then reload the data. There may be functions in Oracle 8i has any functions that might do this for you, or perform string conversions. Another option which would be full of difficulty would be converting the strings into UTF-7 (http://www.free-definition.com/UTF-7.html) before inserting into the database, and then converting from UTF-7 to Unicode when you read from the database. -- Jason Lea --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
