On Aug 23, 2004, at 1:22 PM, Peter Eisentraut wrote:
> Because LIKE does a character-by-character matching and = uses the
> operating system locale, which could do anything. If you set the
> locale to C, you should get matching results. Which one is "better"
> depends on the semantics of the language, which I cannot judge here.
Thanks. So I need to set the locale to C and then LIKE will work
properly? How do I go about doing that? I can see these options:
String sort order
Character classification (What is a letter? The upper-case equivalent?)
Language of messages
Formatting of currency amounts
Formatting of numbers
Formatting of dates and times
Is one of these the one I need to set?
In response to
pgsql-general by date
|Next:||From: Ian Barwick||Date: 2004-08-23 20:58:45|
|Subject: Re: UTF-8 and LIKE vs =|
|Previous:||From: Joshua D. Drake||Date: 2004-08-23 20:33:44|
|Subject: Re: Unsupported 3rd-party solutions (Was: Few questions|