Thread: 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
Attachment
> 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/