Hi, I downloaded postgres 8.4 in zip format and installed it under c:\postgres用�裘� on a traditional Chinese windows 2003 server. Note the Chinese characters in the folder name. Then I tried to create a database using initdb. I specified the following command:
initdb.exe --encoding UTF-8 -D c:\mydb\db --username user1 �CW �CL c:\postgres用�裘�\share The command failed with the following output. It failed while loading system objects description. The command works fine if I install postgres on a folder containg only ascii characters. The files belonging to this database system will be owned by user "Administrator ". This user must also own the server process. The database cluster will be initialized with locale Chinese_Taiwan.950. initdb: could not find suitable text search configuration for locale Chinese_Tai wan.950 The default text search configuration will be set to "simple". creating directory c:/BCA-Networks-Data/db ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers/max_fsm_pages ... 32MB/204800 creating configuration files ... ok creating template1 database in c:/BCA-Networks-Data/db/base/1 ... ok initializing pg_authid ... ok Enter new superuser password: Enter it again: setting password ... ok initializing dependencies ... ok creating system views ... ok loading system objects' descriptions ... FATAL: invalid byte sequence for encoding "UTF8": 0xa5 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding". child process exited with exit code 1 initdb: removing data directory "c:/mydb/db" Can someone please help me to solve this issue? Thanks Sudipta
