Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!news.maxwell.syr.edu!postnews1.google.com!not-for-mail
From: c.clarke@talis.com (Chris Clarke)
Newsgroups: comp.databases.oracle.server
Subject: Re: =?ISO-8859-1?Q?oracle_replace_"_'_"_with_=BF_on_a_insert_statement!!?=
Date: 10 Oct 2003 06:01:27 -0700
Organization: http://groups.google.com
Lines: 18
Message-ID: <10304d3b.0310100501.595f4e8a@posting.google.com>
References: <81644a0f.0310090643.b806ecf@posting.google.com> <3f859893.1089316@news.inet.tele.dk>
NNTP-Posting-Host: 194.80.16.2
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1065790887 14640 127.0.0.1 (10 Oct 2003 13:01:27 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 10 Oct 2003 13:01:27 +0000 (UTC)
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:244999

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@news.inet.tele.dk>...
> On 9 Oct 2003 07:43:09 -0700, mikechico75@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