| From: | Martin Christensen <knightsofspamalot-factotum(at)mail1(dot)stofanet(dot)dk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [Solved] SQL Server to PostgreSQL |
| Date: | 2000-09-02 21:05:45 |
| Message-ID: | 87r972h73c.fsf@fangorn.inspocknito |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
>>>>> "Radoslaw" == Radoslaw Stachowiak <radek(at)alter(dot)pl> writes:
Radoslaw> Does varchar(188) takes 188 bytes (+ bytes for length
Radoslaw> storage) every time, no matter if it contains 'my text' or
Radoslaw> 'my long 188 char text.....' ?
The way I understand it varchar(n) is variable-length, while char(n)
is fixed-lenght. Thus the behaviour you describe above is that of
char(n).
Martin
--
GPG public key: http://home1.stofanet.dk/factotum/gpgkey.txt
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gary MacDougall | 2000-09-02 22:33:10 | Re: jdbc connection refused, please help |
| Previous Message | Jeff Waugh | 2000-09-02 19:11:33 | Re: Increasing system speed by using -F option |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Mascari | 2000-09-02 21:35:17 | Re: Isn't non-TEST_AND_SET code long dead? |
| Previous Message | pgsql-bugs | 2000-09-02 20:00:01 | unique/references not honored when inheriting tables |