| 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: | Whole Thread | Raw Message | 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
| 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? |