utf-8 support in libc?

Vivek Khera vivek at khera.org
Mon Mar 20 17:21:09 UTC 2006


On Mar 20, 2006, at 12:16 PM, [LoN]Kamikaze wrote:

> If you make sure that your data goes into the database in a binary  
> safe
> form (look for escape methods supplied by your favourite programming
> language) it doesn't matter how the database is encoded, because you
> will always get the data back the way you put it in.

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.


>
> Vivek Khera wrote:
>> Reading thru one of the postgres mailing lists regarding which  
>> character
>> encoding to use for a database, someone chimed in and claimed this:
>>
>>  Umm, you should choose an encoding supported by your platform and  
>> the
>>  locales you use. For example, UTF-8 is a bad choice on *BSD because
>>  there is no collation support for UTF-8 on those platforms. On
>>  Linux/Glibc UTF-8 is well supported but you need to make sure the
>>  locale you initdb with is a UTF-8 locale. By and large postgres
>>  correctly autodetects the encoding from the locale.
>>
>> Is this an accurate claim for FreeBSD?  I need to have a UTF-8  
>> encoded
>> database in an upcoming project, and performance is always a concern.
>>
>> Thanks.
>>
>> _______________________________________________
>> freebsd-stable at freebsd.org mailing list
>> http://lists.freebsd.org/mailman/listinfo/freebsd-stable
>> To unsubscribe, send any mail to "freebsd-stable- 
>> unsubscribe at freebsd.org"
>>
>>



More information about the freebsd-stable mailing list