Shilpa Nalgonda wrote:
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.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]
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]
