Forum OpenACS Q&A: Response to Conversion from half-width to full-width Japanese kana characters

In case I forgot to mention it, you need to set the LANG=C for the
environment before you do an initdb, in order to get Postgres
to use binary sort order on strings. Otherwise, sorting
Japanese kana strings will not give you useful results. Using
binary order on Unicode more or less works for kana.