我很确定postgres varchar是相同的Oracle / Sybase / MSsql nvarchar,即使它在手册中不是显式的:
http://www.postgresql.org/docs/7.4/static/datatype-character.html
编码转换函数在这里:
http://www.postgresql.org/docs/current/static/functions-string.html
http://www.postgresql.org/docs/current/static/functions-string.html#CONVERSION-NAMES
例:
create table nvctest ( utf8fld varchar(12) ); insert into nvctest select convert('Postgresql' using ascii_to_utf_8); select * from nvctest;
此外,还有一个类似的问题从Postgresql代表this response:
All of our TEXT datatypes are multibyte-capable,provided you’ve installed Postgresql correctly. This includes: TEXT (recommended) VARCHAR CHAR