varchar lengths

From: Marcus Engene <mengpg2(at)engene(dot)se>
To: POSTGRESQL <pgsql-general(at)postgresql(dot)org>
Subject: varchar lengths
Date: 2010-09-21 09:40:51
Message-ID: 4C987DA3.9050405@engene.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi list,

In Oracle I can...
create table a
(
b varchar2(10 chars)
);
...and then, regardless of character encoding and how much space an
ascii character vs a ö takes, 10 characters will fit there.

If I do say a web-thing in php I have to do horrors like...
if (10 < mb_strlen ($b, '8bit'))
{
// fail to explain to the user why it's too long
}

I could be liberal with the length and instead do a...
create table a
(
b varchar(40)
);
...but I like constraints and this isn't a mysql list so I don't have to
motivate that.

Is there anything I've misunderstood? How does the rest of you deal with
this situation?

Thanks,
Marcus

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A B 2010-09-21 09:42:41 What is the effect of locale on numbers?
Previous Message Craig Ringer 2010-09-21 04:50:31 Re: where does postgres keep the query result until it is returned?