Date: Mon, 20 Mar 2006 12:26:23 -0500 From: "Brandon S. Allbery KF8NH" <allbery@ece.cmu.edu> To: Vivek Khera <vivek@khera.org> Cc: , Kamikaze <LoN_Kamikaze@gmx.de>, LoN, freebsd-stable@freebsd.org Subject: Re: utf-8 support in libc? Message-ID: <43B3539D-F388-4D88-9D3C-F14B36CB2FA7@ece.cmu.edu> In-Reply-To: <1E32EDEA-55BD-4E5A-A1F6-9AEE92A6A5A6@khera.org> References: <1CC90809-B601-425F-AA6C-9927F7EA97AA@khera.org> <441EE362.8060008@gmx.de> <1E32EDEA-55BD-4E5A-A1F6-9AEE92A6A5A6@khera.org>
next in thread | previous in thread | raw e-mail | index | archive | help
On Mar 20, 2006, at 12:21 , Vivek Khera wrote: > I expect that to happen. What I'm more curious about is the > collating speed. Ie, how fast are the sorting and string > comparison functions. The clam here is that in *BSD these are > somehow not fast. I'm not sure if that is a BSD issue or a > Postgres issue for not taking advantage of the BSD functions properly. I don't think that's the issue, so much as that FreeBSD *doesn't support* UTF-8 collation so the database has to use its own (possibly slower than platform-optimized) collation libraries. (en_US.UTF-8/LC_COLLATE is symlinked to a US-ASCII collation sequence which is identical to binary. This is incorrect for UTF-8; there're all kinds of strange things that need to be done to sort UTF-8 properly.) -- brandon s. allbery [linux,solaris,freebsd,perl] allbery@kf8nh.com system administrator [openafs,heimdal,too many hats] allbery@ece.cmu.edu electrical and computer engineering, carnegie mellon university KF8NH
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?43B3539D-F388-4D88-9D3C-F14B36CB2FA7>