When packaging PostgreSQL for Postgres.app, I discovered a problem: strcoll doesn't work for multibyte encodings on OS
X.As a consequence, text sorting in PostgreSQL doesn't work. The only workaround seemed to be to use a legacy encoding
likelatin1, which is inacceptable.<div class=""><br class="" /></div><div class="">I discovered that OS X shares this
limitationwith FreeBSD, and there exists a patch written by Palle Girgensohn that uses the ICU library for collating
stringsinstead of the std-c strcoll function. You can find it at <a class=""
href="http://people.freebsd.org/~girgen/postgresql-icu/README.html">http://people.freebsd.org/~girgen/postgresql-icu/README.html</a></div><div
class=""><brclass="" /></div><div class="">I applied the patch, and according to preliminary testing with 9.4rc1 it
seemsto work flawlessly on OS X as well.</div><div class="">See <a class=""
href="https://github.com/PostgresApp/PostgresApp/releases/tag/9.4rc1">https://github.com/PostgresApp/PostgresApp/releases/tag/9.4rc1</a></div><div
class=""><brclass="" /></div><div class="">I have two questions:</div><div class=""><br class="" /></div><div
class="">1)Does anybody else have experience with this patch? Is it safe to release PostgreSQL binaries with this patch
appliedto the public?</div><div class=""><br class="" /></div><div class="">2) Is there a reason why this patch hasn't
beenmerged into core over the years? Since it requires setting a configure switch (--with-icu) it shouldn't break
anything?</div><divclass=""><br class="" /></div><div class="">Best regards,</div><div class="">Jakob Egger<br class=""
/><divclass=""><br class="" /></div><div class=""><br class="" /></div></div>
