Postgre vs My SQL

[Jiri Chaloupka]

> Jiri Chaloupka wrote:
>> Do "bunky" typu blob muzete ulozit 2GB
>
> 	Rekl bych, ze toto je v dnesni dobe dost strohy limit, ac to mozna

Neni na tom Oracle nahodou podobne :-)?

> jeste neni tak videt. A co treba varchar? (SQL92 definuje max. delku?)
> A co treba neco na zpusob TEXT (samozrejme nenormovano)?
>

Radeji vypis z manualu:

CHARACTER(integer)  or  CHAR(integer)  or  CHARACTER  or  CHAR
For a fixed-length character string of length integer, which may range from
1 to 254. If the length specification is omitted, a length of 1 character is
assumed.


VARCHAR(integer),  or  CHARACTER VARYING(integer),  or  CHAR

LONG VARCHAR
For a varying-length character string with a maximum length of 32700.

BLOB(integer [K | M | G])
For a binary large object string of the specified maximum length in bytes.

The length may be in the range of 1 byte to 2 147 483 647 bytes.

If integer by itself is specified, that is the maximum length.

If integer K (in either upper or lower case) is specified, the maximum
length is 1 024 times integer. The maximum value for integer is 2 097 152.

If integer M is specified, the maximum length is 1 048 576 times integer.
The maximum value for integer is 2 048.

If integer G is specified, the maximum length is 1 073 741 824 times
integer. The maximum value for integer is 2.

To create BLOB strings greater than 1 gigabyte, you must specify the NOT
LOGGED option.

Any number of spaces is allowed between the integer and K, M, or G. Also, no
space is required. For example, all the following are valid.
   BLOB(50K)    BLOB(50 K)    BLOB (50   K)



CLOB(integer [K | M | G])  74
For a character large object string of the specified maximum length in bytes.

The meaning of the integer K | M | G is the same as for BLOB.

To create CLOB strings greater than 1 gigabyte, you must specify the NOT
LOGGED option.


DBCLOB(integer [K | M | G])
For a double-byte character large object string of the specified maximum
length in double-byte characters.

The meaning of the integer K | M | G is similar to that for BLOB. The
differences are that the number specified is the number of double-byte
characters and that the maximum size is 1 073 741 823 double-byte characters.

To create DBCLOB strings greater than 1 gigabyte, you must specify the NOT
LOGGED option.



Chaloupka




-- 
Jiri Chaloupka
B2BExpander.com
chaloupka na b2bexpander.com
**********************************************
Have you visited www.b2bexpander.com today?