<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto">Unicode…. There be dragons. Might be something to do with normalisation form - NFC and NFD say how codes can combine to form different characters - this page <a href="https://www.win.tue.nl/~aeb/linux/uc/nfc_vs_nfd.html">https://www.win.tue.nl/~aeb/linux/uc/nfc_vs_nfd.html</a> might help, or it might not - I was just about getting unconfused with the terminology of Unicode when I stopped looking at it a few years ago :( But weird things could happen. Have you tried a UTF8 client to see what happens (assuming you’ve got an installation where transliteration is available) ?<div><br></div><div>Looking forward to seeing how this pans out !</div><div><br></div><div>Thanks,</div><div>- Tony<br><br><div dir="ltr">Sent from my iPhone</div><div dir="ltr"><br><blockquote type="cite">On 17 Jun 2021, at 13:54, Martin Bowes <martin.bowes@ndph.ox.ac.uk> wrote:<br><br></blockquote></div><blockquote type="cite"><div dir="ltr">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:"Lucida Console";
panose-1:2 11 6 9 4 5 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;
mso-fareast-language:EN-US;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Hi All,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Can someone please explain this one…please use small words…<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">My Linux installation is an ISO-8859-1 charset. We have a table which has an nvarchar(20) column.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Now the Greek mu symbol is U+00B5, a capital-A with a circumflex is 00C2, The ¼ is U+00BC, and a capital-I with a circumflex is U+00CE.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">And in <u>terminal monitor</u> connection, how does this work…<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:72.0pt;text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">select U&'\00c2', U&'\00b5',
<span style="background:yellow;mso-highlight:yellow">U&'\00c2\00b5'</span>\g<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:72.0pt;text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">┌──────┬──────┬──────┐<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:72.0pt;text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">│col1 │col2 │col3 │<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:72.0pt;text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">├──────┼──────┼──────┤<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:72.0pt;text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">│▒ │▒ │µ │<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:72.0pt;text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">└──────┴──────┴──────┘<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:72.0pt;text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">(1 row)<o:p></o:p></span></p>
<p class="MsoPlainText" style="margin-left:72.0pt"><span style="font-size:12.0pt;font-family:"Times New Roman",serif"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:72.0pt;text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">select u&'\00ce', u&'\00bc',
<span style="background:yellow;mso-highlight:yellow">u&'\00ce\00bc</span>'\g<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:72.0pt;text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">┌──────┬──────┬──────┐<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:72.0pt;text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">│col1 │col2 │col3 │<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:72.0pt;text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">├──────┼──────┼──────┤<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:72.0pt;text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">│▒ │▒ │μ │<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:72.0pt;text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">└──────┴──────┴──────┘<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:72.0pt;text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">(1 row)<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">So two weird codes have both combined to make a mu. I didn’t just invent these. I got them from two distinct data sets which were being compared.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">And they are clearly not the same thing.<o:p></o:p></p>
<p class="MsoPlainText"><span style="font-size:10.0pt;font-family:"Lucida Console"">create table test(id integer1, a nvarchar(20));<o:p></o:p></span></p>
<p class="MsoPlainText"><span style="font-size:10.0pt;font-family:"Lucida Console"">insert into test values (1, U&'\00c2\00b5'), (2, U&'\00ce\00bc');<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">select * from test\g<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">┌──────┬────────────────────────────────────────┐<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">│id │a │<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">├──────┼────────────────────────────────────────┤<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">│ 1│µ │<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">│ 2│μ │<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">└──────┴────────────────────────────────────────┘<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">(2 rows)<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console""><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">select a, count(1) from test group by a\g<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">┌────────────────────────────────────────┬─────────────┐<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">│a │col2 │<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">├────────────────────────────────────────┼─────────────┤<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">│µ │ 1│<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">│μ │ 1│<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">└────────────────────────────────────────┴─────────────┘<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Lucida Console"">(2 rows)<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">So could someone please explain this, and also how I can write some code which will say these two mu’s are the same thing.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Marty<o:p></o:p></p>
</div>
<span>_______________________________________________</span><br><span>Info-ingres mailing list</span><br><span>Info-ingres@lists.planetingres.org</span><br><span>https://lists.planetingres.org/mailman/listinfo/info-ingres</span><br></div></blockquote></div></body></html>