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

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle replace " ' " with ¿ on a insert statement!!

Re: oracle replace " ' " with ¿ on a insert statement!!

From: Chris Clarke <c.clarke_at_talis.com>
Date: 10 Oct 2003 06:01:27 -0700
Message-ID: <10304d3b.0310100501.595f4e8a@posting.google.com>


A recent project that I worked on encountered this problem due to character sets and NLS. Suggest you try UTF-16 or UNICODE.

Kenneth Koenraadt wrote in message news:<3f859893.1089316_at_news.inet.tele.dk>...
> On 9 Oct 2003 07:43:09 -0700, mikechico75_at_hotmail.com (Michel) wrote:
>
> >When inserting simple string into varchar(4000) oracle change the '
> >characters into ¿ ....
>
> Hi Michel,
>
> You provide no infomation about platform and version. Remember that...
>
> Anyway, your problem almost certainly has to do with NLS discrepancy,
> for instance your client using a characterset different from/a
> superset of your DB charset.
>
> - Kenneth Koenraadt
Received on Fri Oct 10 2003 - 08:01:27 CDT

Original text of this message

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