Re: varchar lengths

On 21/09/10 10:40, Marcus Engene wrote:
> 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.

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

PostgreSQL actually measures length in characters anyway, so varchar(10)
always holds 10 characters, whatever they are.

You'll need to have the appropriate database encoding for those
characters of course.

--
   Richard Huxton
   Archonet Ltd