|
1 | 1 |
|
2 | 2 | Frequently Asked Questions (FAQ) for PostgreSQL |
3 | 3 |
|
4 | | - Last updated: Sun Jan 1200:16:01 EST 2003 |
| 4 | + Last updated: Sun Jan 1209:58:38 EST 2003 |
5 | 5 |
|
6 | 6 | Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) |
7 | 7 |
|
@@ -839,9 +839,10 @@ BYTEA bytea variable-length byte array (null-byte safe) |
839 | 839 | maximum 1 gigabyte. |
840 | 840 |
|
841 | 841 | CHAR(n) is for storing strings that are all the same length. CHAR(n) |
842 | | - stores trailing spaces, while VARCHAR(n) trims them. BYTEA is for |
843 | | - storing binary data, particularly values that include NULL bytes. |
844 | | - These types have similar performance characteristics. |
| 842 | + pads with blanks to the specified length, while VARCHAR(n) only stores |
| 843 | + the characters supplied. BYTEA is for storing binary data, |
| 844 | + particularly values that include NULL bytes. These types have similar |
| 845 | + performance characteristics. |
845 | 846 |
|
846 | 847 | 4.15.1) How do I create a serial/auto-incrementing field? |
847 | 848 |
|
|