Re: [Solved] SQL Server to PostgreSQL - Mailing list pgsql-general

From Martin Christensen
Subject Re: [Solved] SQL Server to PostgreSQL
Date
Msg-id 87r972h73c.fsf@fangorn.inspocknito
Whole thread Raw
In response to Re: [Solved] SQL Server to PostgreSQL  (Radoslaw Stachowiak <radek@alter.pl>)
Responses Re: [Solved] SQL Server to PostgreSQL  (Jan Wieck <janwieck@Yahoo.com>)
List pgsql-general
>>>>> "Radoslaw" == Radoslaw Stachowiak <radek@alter.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PL/Perl compilation error
Next
From: Jan Wieck
Date:
Subject: Re: [Solved] SQL Server to PostgreSQL