Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Map MS Access Datatypes to Oracle 8i
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 DoeringReceived on Thu Apr 05 2001 - 06:39:38 CDT
![]() |
![]() |