DB and Unicode problem (was: user and DB confusion)
2008/10/13 arnuld uttre <arnuld.mizong@gmail.com>:
On Mon, Oct 13, 2008 at 3:15 PM, Grzegorz Jaśkiewicz
<gryzman@gmail.com> wrote:what does your pg_hba.conf says ?
..SNIP...
local all all ident sameuser
okay, I have changed that line to: local all all trust
and I phpBB can connect to the DB now but with a new problem from
phoBB3: The database you have selected was not created in UNICODE
or UTF8 encoding. Try installing with a database in UNICODE or UTF8
encoding.
what to do about it ?
--
http://uttre.wordpress.com/2008/05/14/the-lost-love-of-mine/
arnuld uttre wrote:
...
and I phpBB can connect to the DB now but with a new problem from
phoBB3: The database you have selected was not created in UNICODE
or UTF8 encoding. Try installing with a database in UNICODE or UTF8
encoding.what to do about it ?
Well exactly that. What information is missing?
There is a parameter on createdb command line
(As well as CREATEDB command in SQL) which
needs to be set to unicode.
Hint: to get collation right, you might want to
initdb first (with empty $PGDATA) with correct
locale settings (including charset UTF-8 which will
then be the default encoding for all subsequent
created databases.
HTH
Tino
On Mon, Oct 13, 2008 at 5:11 PM, Tino Wildenhain <tino@wildenhain.de> wrote:
Well exactly that. What information is missing?There is a parameter on createdb command line
(As well as CREATEDB command in SQL) which
needs to be set to unicode.
yes my friend :) -E utf8
thanks
Hint: to get collation right, you might want to
initdb first (with empty $PGDATA) with correct
locale settings (including charset UTF-8 which will
then be the default encoding for all subsequent
created databases.
default is ISO-8859. I can't make it to UTF8 because then my VLC stops
working :\ . Quite very unusual problem.
--
http://uttre.wordpress.com/2008/05/14/the-lost-love-of-mine/