Next question, how does one actually replace the thing ? replace(thestring,0x2026,'...') ... isn't going to fly. Working with binary values in PG isn't at the top of my resume :-)
On Fri, Oct 30, 2020 at 12:20 PM Tim Clarke <tim.cla...@minerva.info> wrote: > > On 30/10/2020 16:03, David Gauthier wrote: > > psql (11.5, server 11.3) on linux > > I'm using MS-Access as a Windows front-end to a PG DB table through ODBC > (PostgreSQL Unicode ODBC Driver). Seems to be working fine except for when > users enter "..." as part of a string, MS (in it's infinite wisdom) decides > to translate that to what emacs is describing as... > > character: … (displayed as …) (codepoint 8230, #o20046, #x2026) > preferred charset: unicode (Unicode (ISO10646)) > code point in charset: 0x2026 > > It makes this translation for some users but not others, so I'm assuming > it has something to do with how individuals set up their Windows env. No > matter, assume we can't have them change their environment in whatever soln > we come up with. > > I want to change the 0x2026 to the 3 periods which the user entered. > > I was thinking of a pre-insert and pre-update trigger which could make the > translation. But I'd rather not try to do this one char at a time... > translate "..." today to fix today's issue, then "--" tomorrow when that > pops up, then the way MS translates double quotes the next day, etc... . > Is there an elegant way to do this ? > > Thanks In Advance for any help ! > > > IMHO this is the spelling functionality from Office/Access "correcting" > your typing, you can probably see it happening as you type and tapping the > escape key immediately afterwards undoes the "suggestion". You're right in > that it would need either a desktop change per user or a translation table. > You can find all the changes though and do them all at once which saves > your "next day, next day...." issue? > > Tim Clarke > > > > Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | > Frankfurt: +49 (0)69 7191 6000 | Hong Kong: +852 5803 1687 | Toronto: +1 > 647 503 2848 > Web: https://www.manifest.co.uk/ > > > > Minerva Analytics Ltd - A Solactive Company > 9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | United > Kingdom > > ------------------------------ > > Copyright: This e-mail may contain confidential or legally privileged > information. If you are not the named addressee you must not use or > disclose such information, instead please report it to ad...@minerva.info > Legal: Minerva Analytics is the trading name of: Minerva Analytics Ltd: > Registered in England Number 11260966 & The Manifest Voting Agency Ltd: > Registered in England Number 2920820 Registered Office at above address. > Please Click Here https://www.manifest.co.uk/legal/ for further > information. >
