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: Varchar2 and maximum allowed

Re: Varchar2 and maximum allowed

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/01/30
Message-ID: <38941537.6AF1@yahoo.com>#1/1

Kinna Patel wrote:
>
> I currently have an Access database with a memo field in it. I have
> mapped the memo field to a VARCHAR2 field type under Oracle and set
> the limit to 2000.
>
> Does anyone know the maximum amount of text that can be entered in a
> varchar2 field type?
>
> Thanks in advance.

2000 for O7

4000 for O8

-- 
===========================================
Connor McDonald
"These views mine, no-one elses etc etc"
connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue."
Received on Sun Jan 30 2000 - 00:00:00 CST

Original text of this message

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