Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: BUG #4328: help in creating database encoded with LATIN1
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: andrew victoria <rtz_andy(at)yahoo(dot)com>
- Cc: pgsql-bugs(at)postgresql(dot)org
- Subject: Re: BUG #4328: help in creating database encoded with LATIN1
- Date: Mon, 28 Jul 2008 11:22:21 -0400
- Message-id: <20080728152221.GB14617@alvh.no-ip.org> <text/plain>
andrew victoria wrote: > i got an error message > createdb: database creation failed: ERROR: encoding LATIN1 does not match > server's locale en_US.utf8 > DETAIL: The server's LC_CTYPE setting requires encoding UTF8. > > when im trying to create a database encoded with LATIN1 which is needed in > our work. what will i do? You need to run initdb again, specifying --locale=en_US. You can't create a database whose encoding does not match the locale used by initdb. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
- References:
- BUG #4328: help in creating database encoded with LATIN1
- From: andrew victoria
- BUG #4328: help in creating database encoded with LATIN1
- Prev by Date: RES: BUG #4322: Problems with field not updatable
- Next by Date: Re: BUG #4329: Transaction model changed?
- Previous by thread: BUG #4328: help in creating database encoded with LATIN1
- Next by thread: Re: BUG #4328: help in creating database encoded with LATIN1
- Indexes: