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

Popular posts from this blog

javascript - Count length of each class -

What design pattern is this code in Javascript? -

hadoop - Restrict secondarynamenode to be installed and run on any other node in the cluster -