Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Insert problems
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.
> > å=å
> 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