On Jan 16, 2007, at 11:52 , Jerry LeVan wrote:
The locale function on the mac has everything set to "C" and on the linux box it is all "en_US.UTF-8". Is there a simple way to get the collating sequences to be the same on both boxen?
My understanding is that to have the same ordering you need to have initdb'd with the same locale on both machines. Hopefully PostgreSQL will have better collation support in the future.
Michael Glaesemann grzm seespotcode net