无效的语言环境名称 Chinese (Simplified)_People''s Republic of China.936

pg9.6 或 pg10 在Windows Server 2012 R2 DataCenter 中使用。

使用如下建库语句，建库时

CREATE DATABASE upmap 
WITH 
OWNER = postgres 
ENCODING = 'UTF8'    
LC_COLLATE = 'Chinese (Simplified)_People''s Republic of China.936' 
LC_CTYPE = 'Chinese (Simplified)_People''s Republic of China.936'    
TABLESPACE = up_map    
CONNECTION LIMIT = -1;

出现如下错误：（无效的语言环境名称 Chinese (Simplified)_People''s Republic of China.936）

　　

 

 

解决办法：

　　1、查看  安装目录的\PostgreSQL\9.6\data  文件夹中的  postgresql.conf  文件中

　　找到如下配置：

# These settings are initialized by initdb, but they can be changed.
lc_messages = 'Chinese (Simplified)_China.936'            # locale for system error message
                    # strings
lc_monetary = 'Chinese (Simplified)_China.936'            # locale for monetary formatting
lc_numeric = 'Chinese (Simplified)_China.936'            # locale for number formatting
lc_time = 'Chinese (Simplified)_China.936'                # locale for time formatting

 

　　2、修改建库语句中的语言指定 　　

　　将

　　　　Chinese (Simplified)_People''s Republic of China.936

　　修改为

　　　　Chinese (Simplified)_China.936

CREATE DATABASE upmap    
WITH    
OWNER = postgres    
ENCODING = 'UTF8'    
LC_COLLATE = 'Chinese (Simplified)_China.936'    
LC_CTYPE = 'Chinese (Simplified)_China.936'    
TABLESPACE = up_map    
CONNECTION LIMIT = -1;