[Info-ingres] When is upper a downer? When its not a micro lower.

Martin Bowes martin.bowes at ndph.ox.ac.uk
Fri Oct 19 14:09:01 UTC 2018


Hi All,

On both ingres10.2 and 11.0…

We have some text fields in which the Mu symbol ‘b5’ has crept in to symbolise a micro quantity. Eg (‘5-100µl’)

So what happens when you:

select upper(x'b5')\g
E_AD5015 0000B5FE, is not a valid byte sequence for server codepage.

select lower(x'b5')\g

┌──────┐
│col1  │
├──────┤
│�     │
└──────┘
(1 row)

Martin Bowes
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20181019/8583ff38/attachment.html>


More information about the Info-ingres mailing list