Re: Selecting values from Tables with columns of VARCHAR type

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 25 Jun 2001 15:52:18 +0100
Message-ID: <3b375025$0$12244$ed9e5944@reading.news.pipex.net>

varchar2(n) stores a variable length string of upto n characters.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Tom Klinger" <admin_at_the-piper.net> wrote in message
news:3b373e68$1_at_news.i-one.at...


>

> "Tom Klinger" <admin_at_the-piper.net> wrote in message

> news:3b373d96$1_at_news.i-one.at...

> > Hi!

> >

> > Normally not a problem, but for me currently a mysterium.

> >

> > I have a couple of tables which contain columns with a VARCHAR(2000)

 field.


> > Now, selecting from it gives me a number.

> > Can anyone help how the heck I can select something from there? From the

> > database definition of the vendor a string should be stored there.

> >

>

> Sorry, little bit wrong information. It's a VARCHAR2 type in an Oracle

> 8.0.6i database. What could this be?

>

> Tom

>

>

Received on Mon Jun 25 2001 - 09:52:18 CDT