mono, xsp, postgresql, chinese problem

joint

using xsp as standalone http server

1. mono-1.1.4
./configure --prefix=/opt/mono --with-preview=yes
make; make install

export PATH=$PATH:/opt/mono/bin

2. xsp-1.0.6
./configure --prefix=/opt/mono

# edit /opt/mono/bin/xsp here
rm -rf /tmp/root-temp-aspnet/*

/opt/mono/bin/mono "/opt/mono/lib/mono/1.0/xsp.exe" --root /data/xsp80 --port 80 --nonstop &

3. postgresql-8.0.1
./configure --prefix=/opt/postgres

createdb -E unicode testdb

edit postgresql.conf: listen_addresses = '192.168.1.2'.

edit pg_hba to enable remote connection.

--------------------------------------------------------------------
4. solve chinese problem of xsp
must save html, aspx files with encoding utf8

--------------------------------------------------------------------
5. solve chinese problem of database
add Encoding=UNICODE to your connection string