postgres string type compatibility: varchar and character

Question

On my postgresql database, i've declared all String field as

character(n)

Now i have some function that takes string argument as

varchar(n)

are this two datatype compatible or should i change type in function or in table declarement?

Don't use char or character, they're horrible legacy data types with surprising and confusing behaviours. Use varchar or text. — Craig Ringer
– Craig Ringer, Commented Jul 11, 2013 at 9:02
i was using character instead varchar because of some mysql scripting habit :) now i've modify all my db — giozh
– giozh, Commented Jul 11, 2013 at 9:07

Ihor Romanchenko · Accepted Answer · 2013-07-11 08:45:31Z

1

Character types character(n) and varchar(n) are compatible and internally are the same type (but have different representation, when queried).

answered Jul 11, 2013 at 8:45

Ihor Romanchenko

29k9 gold badges56 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1