> Could this not be done as part of the initialization of the > SL dataset? I run different language versions of my machine > and setting the locale globally for the postgresql user > is not adequate.
Of course you could initialize the database using UNICODE and then, while creating the databases, set the LC_ALL for each different installation for the user account, which is creating the DB. Since I am rather lazy I just did it that way, so I would not have to fiddle around in the installation routine of SL... Ciao Rainer > > Hi, > > > > found the solution: > > The PostgreSQL database has to do the sorting correctly. > > Therefore the following steps are required: > > > > As database admin (User ID postgres) initialize the > database with the locale set correctly and appropriate > encoding. In my case this was: > > > > export LC_ALL=de_DE > > initdb -E LATIN1 > > > > Of course you will have to delete all your data before this > step so you would want to pg_dump your database content > first, and then reimport it as described in the manpage of pg_dump. > > > > When you now create a new database in admin.pl it will use > the default LATIN1 for encoding and the LC_ALL used during initdb. ------------------------------------------------------- This sf.net email is sponsored by: Dice - The leading online job board for high-tech professionals. Search and apply for tech jobs today! http://seeker.dice.com/seeker.epl?rel_code=31 ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/
