>Hi,
>
>I installed postgres 8.0 for windows on my win xp (Simplified Chinese
>version). The encoding is unicode. When I set pgsql client encoding to
>gb18030, I could insert Chinese text from the command line to
>postgres.
>
>However, I could not get the sort order of Chinese varchar field to
>work properly.
>
>What I tried are as follows:
>
>1) installed postgres for windows and used the "C" locale.
>2) installed postgres for windows and used the "Chinese, PRC" locale.
>
>Again, in both cases, the backend encoding is unicode.
Sorting is not currently supported in the UNICODE/UTF-8 encoding on
Win32. Sorry. You need to pick a specific non-unicode encoding/locale
combination. (Or run the server on a platform that supports it, if that
is an option)
//Magnus