Re: postgreSQL UPPER Method is converting the character "µ" into "M"

Поиск
Список
Период
Сортировка
От Helmut Bender
Тема Re: postgreSQL UPPER Method is converting the character "µ" into "M"
Дата
Msg-id 7934e62f-516b-820d-1d37-7b915f5dd7a4@helmut-bender.de
обсуждение исходный текст
Ответ на Re: postgreSQL UPPER Method is converting the character "µ" into "M"  (Sai Teja <saitejasaichintalapudi@gmail.com>)
Ответы Re: postgreSQL UPPER Method is converting the character "µ" into "M"  (Joe Conway <mail@joeconway.com>)
Список pgsql-general
Дерево обсуждения 
Am 06.09.23 um 16:04 schrieb Sai Teja:
> In my local it is windows OS and locale is English_united_states.1252 
> and in local it is converting as expected ( testµ into TESTµ)

You wrote PostgreSQL is hosted on an utf-8 system. That's why it's 
working different.

And be careful: the M isn't the uppercase latin m, but in fact the 
uppercase µ (U+039C in unicode)! If you would compare it to latin 
alphabet 'TESTM' it would be different.

-- 
Gruß Helmut

В списке pgsql-general по дате отправления:

Предыдущее
От: Albrecht Dreß
Дата:
Сообщение: Q: inet operators for IPv4 encapsulated in IPv6
Следующее
От: Francisco Olarte
Дата:
Сообщение: Re: postgreSQL UPPER Method is converting the character "µ" into "M"