Re: Do I need to create a field type LONG?
Date: Tue, 04 May 2004 14:00:51 GMT
Message-ID: <nmNlc.20901$IG1.865525_at_attbi_s04>
"Galina" <galkas_at_mail.ru> wrote in message
news:ecdc865.0405040457.25b3d48a_at_posting.google.com...
> Thank you both for answering. I have already re-created the table with
> the field type Varchar2 length 1000.
> Simply for curiosity, when I copy a string shorter then 1000 into this
> field, will Oracle use memory necessary to store the string, or to
> store 1000 characters long string? Sorry for silly question, I
> understand that I could have found it somewhere...
> Galina
> galkas_at_mail.ru (Galina) wrote in message
news:<ecdc865.0404290204.79ae76df_at_posting.google.com>...
> > Hello
> > I am going to copy a data from MS Access table into Oracle table. One
> > of fields is memo type and data in this field range from 1 character
> > to 551 long string. Do I need to create a field type LONG in the
> > Oracle table to accommodate this data? If not, what field type would
> > suit best?
> > Any help will be greatly appreciated.
> > Thank you.
> > Galina
It stores the string as is. It does not pad the string. So if the string
is of length 2 then it takes up 2 (plus one for the column delimiter)
Jim
Received on Tue May 04 2004 - 16:00:51 CEST