Forum OpenACS Q&A: Response to Support for multibyte: .tcl ok .adp not
I compiled postgres as follows:
./configure --enable-locale --enable-recode --enable-multibyte --enable-unicode-conversion --with-maxbackends=64 --with-tcl --with-tclconfig=/usr/local/lib --with-perl --with-python --with-openssl --with-CXX --enable-syslog
and created db's in UNICODE. My configuration file is same as the one posted by Henry except I changed the shift_jis to big5.
There is no upper/lower case in big5 (in fact, in Chinese). So I can not be helpful to test out your problem. sorry about that.
I did try patch the ad_return_template as you suggested but it still output juck characters as before. I think it is caused by the "ns_adp_parse -file" which does not honor the charset conversion as Henry suggested.
I removed the default adp mapping to adp parser as you suggested and the "pure" .adp's work fine with this change. But the problem remains in the ad_return_template which is in use in serveral modules in openacs, such as ecommerce,gp and sdm etc. Do you have any suggestions on what to change to make use on the templated .adp pages called by ad_return_template ?