NCHAR type is provided as the data type to deal with national characters.
The NCHAR type can be used with Fujitsu Enterprise Postgres pgAdmin.
Point
NCHAR can only be used when the character set of the database is UTF-8.
NCHAR can be used in the places where CHAR can be used (function arguments, etc.).
For applications handling NCHAR type data in the database, the data format is the same as CHAR type. Therefore, applications handling data in NCHAR type columns can also be used to handle data stored in CHAR type columns.
Note
Note the following in order to cast NCHAR type data as CHAR type.
When comparing NCHAR type data where the length differs, ASCII spaces are used to fill in the length of the shorter NCHAR type data so that it can be processed as CHAR type data.
Depending on the character set, the data size may increase by between 1.5 and 2 times.
Use the AS clause to specify "varchar" as the column alias.
