Forum OpenACS Q&A: Sort order for Japanese text
We have the db configured to use Unicode, all translation from SJIS is done in AOLserver. Here's the configuration I used to init the database and to run the server:
export LANG=C /usr/local/pgsql/bin/initdb --encoding unicode - D /usr/local/pgsql/data and we also have this set when we launch Postgres server in rc.local su -l postgres -c 'export LANG=C; /usr/local/pgsql/bin/postmaster -N 200 -B 1000 -o "-S 2000" -S -D / usr/local/pgsql/data '
./configure --enable-locale --enable-recode --enable-multibyte --enable-unicode-conversion --with-maxbackends=64 --with-tcl --with-perl --with-openssl --with-CXX --enable-syslog export LANG=C /usr/local/pgsql/bin/initdb --encoding unicode -D usr/local/pgsql/data
And... If it is needed to configure Postgresql again, is there a possibility to do this with the rpm installation as well? (Sorry, these rpms which work very well, especially on RH 7.1, have made me lazy. Not only that, mixing rpm with tarball installations does not work very well...)
E 'accent grave', 'accent aigue', 'accent circonflexe', a Umlaut, etc. if my French and German is right...
echo LANG=C >>/etc/sysconfig/i18nand then install the Postgresql RPMs for the "first time" (ie you must NOT have a PG database already existing, rm -rf /var/lib/pgsql if necesary). Once the postgresql-server RPM is installed and you start PG for the first time, you can then remove the LANG=C line from the /etc/sysconfig/i18n file once more.