LC_COLLATE = UTF8: How to?

Hi. I have been told that LC_COLLATE is set at the initdb stage. Which means I will have to reinstall Postgresql.

Could someone please tell me how I can use MAPP but specify LC_COLLATE as UTF8 instead of the defaults?

Thanks

Hi, this is something that we will need to add ourselves to the installers (or at least allow people to choose) As a workaround, you may want to delete the existing database and try running the following yourself:

export LC_COLLATE=whatever_you_want_it_to_be

/path/to/installdir/postgresql/bin/initdb -U postgres

Thanks Daniel. The export command alone did not work. PG still installs with SQL_ASCII. Looking around the initdb help, I found that I need to issue this command:

/Applications/mappstack09/postgresql/bin/initdb -U postgres—lc-collate=UTF-8—encoding=UTF8

Hope this helps someone. Thanks!

Actually this doesn’t work either. I think the whole database needs to be installed with UTF-8 enabled during compile time :(