Re: Map MS Access Datatypes to Oracle 8i

From: Dmitry <support_at_ispirer.com>
Date: Fri, 6 Apr 2001 15:31:07 +0300
Message-ID: <9akcu8$5a8s7$1@ID-75577.news.dfncis.de>

As far as I know Oracle 7 varchar2 limit is 2000 symbols.

Best regards, Dmitry

--
http://www.ispirer.com/chyfo.html - Tool exports data to CSV flat file,
generates CREATE TABLE, CREATE INDEX scripts for Oracle and control files
for SQL Loader.


"Martin Doering" <doeringm_at_gmx.de> wrote in message
news:3acc54c3.277633736_at_news.mn.man.de...


> On Thu, 5 Apr 2001 13:08:17 +0300, "Dmitry" <support_at_ispirer.com>

> wrote:

>

> >Use NUMBER(10) for Access LONG, NUMBER for Double and CLOB for Access

 MEMO.


>

> There had been a change since my last posting. I now have to use a

> 7.3.4 Instance. I think clob is not available, and LONG is not allowed

> for more than one column. So I will have to use varchar2 for that. I

> did some statistice, how full the largest fields are. So 1000 chars

> will be ok.

>

> At last, thanx for your help...

>

>

> ---

> Martin Doering

Received on Fri Apr 06 2001 - 07:31:07 CDT