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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Insert problems

Re: Insert problems

From: <henke01_at_my-deja.com>
Date: 2000/05/24
Message-ID: <8gg5g9$uq3$1@nnrp1.deja.com>#1/1

In article <8g0ua4$5fo$1_at_nnrp1.deja.com>,   jeanch_at_my-deja.com wrote:
> In article <8g0q6l$gg$1_at_nnrp1.deja.com>,
> henke01_at_my-deja.com wrote:
> > I'm trying to insert a string into a table.
> > The string i a part of a webpage and it contains some sign that the
> > webbrowser translate to for example (åäö) Swedish.
> > å=&aring;
> ampersand sign suggests to oracle that you want to interact and enter
> the value of aring. That's it's a reserved character; But I think if
> your NLS is properly set up to your local language then oracle will
> accept this charater no problem.

Is there any way to make Oracle escape it?

> > But when I insert this I get a question:
> >
> > Enter value for aring:
> >
> > The column is a varchar.
> > Why?
> > I have tried to get info about the & but I can't find any.
> >
> > Thanks
> > Henrik
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed May 24 2000 - 00:00:00 CDT

Original text of this message

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