Can I use nvarchar data type in plpgsql?

postgresql

Solution

Just use the `text` or `varchar` types.

There's no need for, or support for, `nvarchar`. All PostgreSQL text-like types are always in the database's text encoding, you can't choose a 1-byte or 2-byte type like in MS SQL Server. Generally you just use a UTF-8 encoded DB, and everything works with no hassle.

Problem

Original source