Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 8.1.6 OCI JDBC Driver issue with NON ASCII Characters

Re: Oracle 8.1.6 OCI JDBC Driver issue with NON ASCII Characters

From: Rajesh Shah <send2rajesh_at_hotmail.com>
Date: 7 Sep 2003 06:03:02 -0700
Message-ID: <49e7a800.0309070503.5c67e81@posting.google.com>


"Amit" <jindal_at_roguewave.com> wrote in message news:<bj36pp$vi9$1_at_tux.cvo.roguewave.com>...
> Though I am not sure what you might need to change, Oracle thin driver use
> OCI underneath that is a C library and does not relies on Unicode as pure
> JDBC driver does.
> Maybe that's why you are seeing the difference.
> Try printing these characters out to a log file or something and see if its
> the MS-Word that is causing trouble.
>
> --
> -----------------------------------------------------------------
> Amit Jindal, Development Engineer
>
> Want ease of development or performance? Why not get both!
> http://www.roguewave.com/products/sourcepro/db/
>
> [Disclaimer: All views expressed here are my personal views
> and they can be incorrect at times]
> -----------------------------------------------------------------
>
> "Rajesh Shah" <send2rajesh_at_hotmail.com> wrote in message
> news:49e7a800.0309020652.41dc5adb_at_posting.google.com...
> > I am using HTML form to submit data to Oracle 8.1.6 database using
> > OCI JDBC driver. The formatted characters like bullets, quotes etc
> > copied from MS Word and pasted in the HTML form are getting saved as
> > '?' character in the database.
> >
> > When I switch to Oracle thin driver the problem goes away.
> >
> > Is there any configuration issue for OCI JDBC driver, that I am
> > missing ?
> >
> > Thanks for help!

The obove problem was because of different char-set OCI driver was using as compared to Oracle database char-set. Setting the NLS_LANG parameter on the box running Oracle client to same as datbase char-set helped solve the problem. Received on Sun Sep 07 2003 - 08:03:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US