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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
