开发者

Postgresql database creation problem with localization

开发者 https://www.devze.com 2022-12-28 22:02 出处:网络
as the output of this command createdb -E UTF8 --lc-collate=hr_HR.UTF8 --lc-ctype=hr_HR.UTF8 tempdb I get

as the output of this command

createdb -E UTF8 --lc-collate=hr_HR.UTF8 --lc-ctype=hr_HR.UTF8 tempdb

I get

createdb: database creation failed: ERROR:  invalid locale name hr_HR.UTF8

I'm a noob in postgresql so any help will be appreciated! As you can see from above command, I need to create database with support for Croatian language. My OS is:

开发者_开发问答
Linux tiho-desktop 2.6.31-20-generic #58-Ubuntu SMP 
Fri Mar 12 04:38:19 UTC 2010 x86_64 GNU/Linux

and it is only for development. I plan to move this database to CentOS or something like it for production. I'm using postgresql 8.4.

Thanks in advance, Tiho


what do you get as the output of locale -a | grep hr_HR?

I can't reproduce the error you get because my createdb doesn't accept the locale parameters (seems the option is only available in 8.4), but you should check that the locale you're setting exists in the output of the above command. Also, you don't need to specify the collaction and ctype separately: the -l switch covers both.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号