Re: UTF-8 and LIKE vs =
От | Robert Treat |
---|---|
Тема | Re: UTF-8 and LIKE vs = |
Дата | |
Msg-id | 1093296686.1700.243.camel@camel обсуждение исходный текст |
Ответ на | Re: UTF-8 and LIKE vs = (David Wheeler <david@kineticode.com>) |
Ответы |
Re: UTF-8 and LIKE vs =
|
Список | pgsql-general |
On Mon, 2004-08-23 at 16:43, David Wheeler wrote: > 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: > > LC_COLLATE > String sort order > > LC_CTYPE > Character classification (What is a letter? The upper-case equivalent?) > > LC_MESSAGES > Language of messages > > LC_MONETARY > Formatting of currency amounts > > LC_NUMERIC > Formatting of numbers > > LC_TIME > Formatting of dates and times > > Is one of these the one I need to set? > initdb is your friend. (well, not really, but that's where your headed) Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
В списке pgsql-general по дате отправления: