Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 8.1.6 OCI JDBC Driver issue with NON ASCII Characters
"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
![]() |
![]() |