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: Map MS Access Datatypes to Oracle 8i

Re: Map MS Access Datatypes to Oracle 8i

From: Martin Doering <doeringm_at_gmx.de>
Date: Thu, 05 Apr 2001 11:39:38 GMT
Message-ID: <3acc54c3.277633736@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 Thu Apr 05 2001 - 06:39:38 CDT

Original text of this message

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