On Wed, 6 Sept 2023 at 16:40, Sai Teja <saitejasaichintalapudi@xxxxxxxxx> 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.
