Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Long Char field
hi,
i'm french so if my english is very poor. sorry.
I used Oracle 7.3 with oracle odbc driver 2.5.3.1.7 .
I have problem with long raw field. it's difficult to have information about this. But, i tried to have information. i explain my matter. I used SQLPutData to put a field in long raw and in my function i passed on SQLBindParameter function a parameter SQL_LONGVARBINARY. but if my file is less than near 4 there is an error. If i passed on my function SQL_VARBINARY not SQL_LONGVARBINARY there is no problem. But if my file is more than 4 with SQL_VARBINARY the field is no record.
which is the critical size of field to put SQL_VARBINARY or
SQL_LONGVARBINARY ??
thanks.
Xav
@+
Markus Schwabe <mschwabe_at_gscout.de> a écrit dans le message :
8gleg8$q34$1_at_news4.muc.eurocyber.net...
> You can either define:
>
> 1) CLOB column (I think in Oracle 8.1.5 and above) :
> A character large object containing single-byte characters.
> Both fixed-width and variable-width character sets are
> supported, both using the CHAR database character
> set. Maximum size is 4 gigabytes.
>
> The built-in LOB datatypes BLOB, CLOB, and
> NCLOB (stored internally), and the BFILE (stored externally),
> can store large and unstructured data such as text, image,
> video, and spatial data up to 4 gigabytes in size.
>
> or:
>
> Try to AVOID the following if you have Oracle 8!!!
> They have many restrictions!
>
> 2) LONG column
> Character data of variable length up to 2 gigabytes
>
> 3) LONG RAW column
> Raw binary data of variable length up to 2 gigabytes
>
> If you have it, look at the docu under
> Oracle8i SQL Reference/Basic Elements of Oracle SQL/Datatypes.
>
> HTH
> Markus
>
>
> Jose A. Silva <jsilvae_at_yahoo.com> schrieb in im Newsbeitrag:
> 8gk1d4$ono9_at_nova.entelchile.net...
> > Is it posible to store a very large text in oracle ? let's say 3 pages
of
> > text.
> > Thanks.
> >
> >
>
>
Received on Fri May 26 2000 - 00:00:00 CDT