How to rewrite this line when porting from MySQL to PostgreSQL?

Question

MySQL

There is a string to define an attribute in MySQL

`STEM` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

How to rewrite it for PostgreSQL?

Answer 1

In postgresql, all text types follow the base encoding. case insensitive utf8 is not provided in pg.
Therefore, if you have a base in utf8 - then "STEM" varchar(50) not null
If the base is not in utf8 - do not do this.