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: <jeanch_at_my-deja.com>
Date: 2000/05/18
Message-ID: <8g0ua4$5fo$1@nnrp1.deja.com>#1/1

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.
> 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. Received on Thu May 18 2000 - 00:00:00 CDT

Original text of this message

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