Forum OpenACS Q&A: Response to howto run 3.2.5 with European characters on nsd8x


1.) I have it almost working, but while Marcin is proposing to create the db with LATIN2 (in my case LATIN1), Henry is proposing UNICODE...

createdb --encoding=unicode yourdb

createdb -E LATIN2 yourdb

Which should I take? (pros - cons...)

2.) I read some threads about occurring problems with improper sorting using upper() or lower(). Is this correct? If yes, what can I do about it? I read something about Lang=C ??!!??

3.) Will there be a problem importing my existing database (sql-ascii), which is not compiled with unicode-conversion, into the newly compiled postgres with unicode-conversion + unicode or Latin1??