postgresql - postgres string type compatibility: varchar and character -
on postgresql database, i've declared string field as
character(n)
now have function takes string argument
varchar(n)
are 2 datatype compatible or should change type in function or in table declarement?
character types character(n)
, varchar(n)
compatible , internally same type (but have different representation, when queried).
details in this article
Comments
Post a Comment