From: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
---|---|
To: | Sai Teja <saitejasaichintalapudi(at)gmail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: postgreSQL UPPER Method is converting the character "µ" into "M" |
Date: | 2023-09-06 15:29:21 |
Message-ID: | CA+bJJbx0NQdKQDw8dQOY+Or0d5m1hnFRBtyc4_KvfPZtG5j30g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 6 Sept 2023 at 16:40, Sai Teja <saitejasaichintalapudi(at)gmail(dot)com> wrote:
> Actually we are migrating the data from DB2 to postgreSQL. So in DB2 the upper method is converting µ as µ only but not as M.
> So, while validating the data we have encountered this problem.
>
> We want to have the data in both DB's should be similar (db2 and postgreSQL)
Data seems to be the same, function behaviour is what seems different.
> 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µ)
Maybe because unicode has GREEK CAPITAL LETTER MU ( 924, which looks
like capital M ), GREEK SMALL LETTER MU ( 956 ) and MICRO SIGN ( 181,
which looks like small mu ) while windows-1252 only has 0xB6 as micro.
OTOH Windows-1253 ( greek ansi ) has all three.
If your small mu are really micro-sign ( which is suspected if youused
1252 ) maybe changing them to that helps ( but I do not have the
resources to test that on hand ).
Francisco Olarte.
From | Date | Subject | |
---|---|---|---|
Next Message | Sai Teja | 2023-09-06 16:04:43 | Re: postgreSQL UPPER Method is converting the character "µ" into "M" |
Previous Message | Helmut Bender | 2023-09-06 15:22:50 | Re: postgreSQL UPPER Method is converting the character "µ" into "M" |