LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 02-23-2014, 01:54 AM   #1
Mankind75
Member
 
Registered: Apr 2004
Location: Brome, Lower Saxony, Germany
Distribution: Slackware, OpenMandriva
Posts: 83

Rep: Reputation: 18
Creating databases with PostgreSQL in UTF-8


Hello everyone,

I am running PostgreSQL which I installed from source on the Slackware 14 Linux distribution. My PostgreSQL-Database server is running fine but now I would like to create a database which needs to be in UTF-8 format.

I tried the following as user "postgres".

Code:
bash-4.2$ /usr/local/pgsql/bin/createdb kivitendo -E=UTF.8
createdb: database creation failed: ERROR:  encoding "UTF8" does not match locale "en_US"
DETAIL:  The chosen LC_CTYPE setting requires encoding "LATIN1".
Code:
bash-4.2# locale
LANG=en_US
LC_CTYPE="en_US"
LC_NUMERIC="en_US"
LC_TIME="en_US"
LC_COLLATE=C
LC_MONETARY="en_US"
LC_MESSAGES="en_US"
LC_PAPER="en_US"
LC_NAME="en_US"
LC_ADDRESS="en_US"
LC_TELEPHONE="en_US"
LC_MEASUREMENT="en_US"
LC_IDENTIFICATION="en_US"
LC_ALL=

I must say that these things about locales and character sets and Template0 and Template1 are confusing me. Could anyone please provide clarification on these issues?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Postgresql - Creating a new database error \/4A Linux - Software 8 04-17-2013 07:46 PM
syncing 2 postgresql databases linuxengineer Linux - Server 1 11-08-2010 02:59 AM
Postgres and creating users/ connecting to databases ? memo007 Linux - Software 3 08-24-2008 08:34 PM
[Enter] in text documents diffrent on Windows and Linux? UTF-8/UTF-16 problem or? brynjarh Linux - General 1 11-24-2004 05:20 AM
show databases; & describe tablename for PostgreSQL Tim K. Linux - Software 5 07-25-2003 02:49 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 01:12 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration