On Mon, Mar 20, 2006 at 06:07:16PM -0500, Vivek Khera wrote: > So, if I use a UTF8 encoded DB on FreeBSD, all hell will break loose > or what? Will things not compare correctly? Where from does the > code to do the collating come, then? It just won't collate properly. PostgreSQL collation is provided by the underlying C library via strcoll(). FreeBSD simply doesn't support UTF-8 collation. IIRC the UTF-8 collation code simply uses the ASCII collation. It's an order, just not the order most people will be expecting. If you look at the collation code in FreeBSD you'll see it doesn't work for any multibyte encoding. That's OK, it's obviously not important to FreeBSD users. But I'm ademantly against building and maintaining a special UTF-8 collation library just for PostgreSQL. That's just reinventing the wheel. There already exist cross-platform libraries to handle collation and we should work towards allowing people to use one of those... Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
Attachment:
signature.asc
Description: Digital signature
