Re: C locale + unicode

Tom, thanks for the info.

Do upper() and lower() only work correctly for postgres v8 UTF-8 encoded
databases? (They don't seem to work on chars > standard ascii on my
7.4.6 db). Is this locale or encoding specific issue?

Is there likely to be a significant difference in speed between a
database using a UTF-8 locale and the C locale (if you don't care about
the small issues you detailed below)?

Thanks.

John Sidney-Woollett

Tom Lane wrote:

> John Sidney-Woollett <johnsw@wardbrook.com> writes:
>
>>Does anyone know if it's permitted to use the 'C' locale with a UNICODE
>>encoded database in 7.4.6?
>
>
> Yes.
>
>
>>And will it work correctly?
>
>
> For suitably small values of "correctly", sure.  Textual sort ordering
> would be by byte values, which might be a bit unintuitive for Unicode
> characters.  And I don't think upper()/lower() would work very nicely
> for characters outside the basic ASCII set.  But AFAIR those are the
> only gotchas.  People in the Far East, who tend not to care about either
> of those points, use 'C' locale with various multibyte character sets
> all the time.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly