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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: postgreSQL UPPER Method is converting the character "µ" into "M"
Дата
Msg-id 1507834.1694008417@sss.pgh.pa.us
обсуждение исходный текст
Ответ на postgreSQL UPPER Method is converting the character "µ" into "M"  (Sai Teja <saitejasaichintalapudi@gmail.com>)
Ответы Re: postgreSQL UPPER Method is converting the character "µ" into "M"  (Sai Teja <saitejasaichintalapudi@gmail.com>)
Список pgsql-general
Sai Teja <saitejasaichintalapudi@gmail.com> writes:
> I am using UPPER document name for converting the text from lower case into
> upper case.
> But here for the below example
> Command:- select UPPER(testµ)
> Input :- testµ
> Output:- TESTM
> Expected output :-  TESTµ

According to https://en.wikipedia.org/wiki/Greek_alphabet
the upper-case form of µ (mu) is in fact M, so I'm not sure
what problem you have with this.  But in any case, you are
complaining in the wrong place.  This conversion is determined
by the rules of the selected locale.  If you don't like it,
choose another locale, or make your own, or try to persuade
the glibc maintainers that they are wrong.

            regards, tom lane



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

Предыдущее
От: Sai Teja
Дата:
Сообщение: postgreSQL UPPER Method is converting the character "µ" into "M"
Следующее
От: Sai Teja
Дата:
Сообщение: Re: postgreSQL UPPER Method is converting the character "µ" into "M"