Postgres 9.2在Windows 7上,我试图创buildEnglish_United States.1252自定义整理 :
user=# create database test template template0 ENCODING = 'utf8' LC_COLLATE = 'English_United States.1252' LC_CTYPE = 'English_United States.1252'; CREATE DATABASE user=# \c test test=# create collation english from "English_United States.1252"; ERROR: collation "English_United States.1252" for encoding "UTF8" does not exist
如您所见,显示以下错误: 错误:对“UTF8”进行编码的sorting规则“English_United States.1252”不存在
在Windows上为utf8 db编码创build英文美国sorting规则的正确方法是什么?