Re: BIGINT support?

I checked your URL which stated that a VARCHAR2 column can hold 4K of chars. Not true, 4K = 4 * 1024 = 4096. A VARCHAR2 can only hold 4000 chars.

• Kenneth Koenraadt

On Sat, 13 Mar 2004 09:19:28 -0800, Daniel Morgan <damorgan_at_x.washington.edu> wrote:

>Jean-Luc Fontaine wrote:
>
>> I am wondering whether Oracle supports something like the
>> BIGINT type (MySQL, PostgreSQL, SQLite, ...), which can handle 64 bits
>> signed numbers:
>> from -9223372036854775808 to 9223372036854775807.
>>
>> After searching on the web, it does not seem so (yet?).
>> Can the 2 extreme numbers above be stored in and read back from a
>> column of some type, and which type?
>> (note: in MySQL, BIGINT is equivalent to BIGINT(20): maybe something
>> like NUMERIC(20,0) would do?.
>>
>> Many thanks in advance,
>>
>>
>> Jean-Luc
>
>http://www.psoug.org/reference/datatypes.html
>
>--
>Daniel Morgan
>http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
>http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
>damorgan_at_x.washington.edu
>(replace 'x' with a 'u' to reply)
>
Received on Sat Mar 13 2004 - 12:29:08 CST