Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle replace " ' " with ¿ on a insert statement!!
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