| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Markus Schaber <schabi(at)logix-tt(dot)com> |
| Cc: | Frank Bax <fbax(at)sympatico(dot)ca>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Field length ?? |
| Date: | 2006-04-20 15:44:25 |
| Message-ID: | 19020.1145547865@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Markus Schaber <schabi(at)logix-tt(dot)com> writes:
> Frank Bax wrote:
>> Except that the original fields were neither variable length datatypes,
>> not type text.
> char is a textual type (in opposite to numeric types), and they are
> handled as variable length datatypes internally (even if given a limit).
char(n) *is* a variable-length type, not merely "handled as such",
because the limit N is measured in characters not bytes. To support
variable-length encodings such as UTF8 we have to treat it as variable
length.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-04-20 16:20:34 | Re: At time zone madness! |
| Previous Message | Markus Schaber | 2006-04-20 15:36:41 | Re: Field length ?? |