Thanks for the info - to the point and much appreciated!
John Sidney-Woollett
Tom Lane wrote:
John Sidney-Woollett <[EMAIL PROTECTED]> writes:
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
John Sidney-Woollett <[EMAIL PROTECTED]> writes:
> 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?
Before 8.0, they don't work on multibyte chara
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
John Sidney-Woollett <[EMAIL PROTECTED]> 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
Does anyone know if it's permitted to use the 'C' locale with a UNICODE
encoded database in 7.4.6? And will it work correctly?
Or do you have to use a en_XX.utf8 locale if you want to use unicode
encoding for your databases?
John Sidney-Woollett
---(end of broadcast)
