It does! The following query converts the data correctly to it normal form. I am going to see if Oracle has any suggestions for a conversion at the DB level. This will make life much easier. Thanks, Joe
select convert(abstract,'WE8ISO8859P1') from aacr20_dba.ms_supplimentary_details where ms_no = 'CAN-06-2483' -----Original Message----- From: Christopher Schultz [mailto:[EMAIL PROTECTED] Sent: Monday, August 13, 2007 5:24 PM To: Tomcat Users List Subject: Re: character encodingg problem -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Joe, Russo, Joe wrote: > Chris, > Thank you very much for you response. I am going to try and look at how > long it will take to do this type of conversion for 39 databases. Ouch! Perhaps your database supports a query that might be able to do this faster -- that is, without writing a Java program to do it. - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGwMvl9CaO5/Lv0PARAnwaAJ4z5jE2pKQv9TEN8cR6nigU3mgu2gCgpkTh anFJVL+pk7uiubWenulxzVE= =7teY -----END PGP SIGNATURE----- --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
