I have a spool formatting problem after moving from sqlcl version 4.2 on Windows 7 to 18.1 on Windows 10
In our database we use the character "¬" (unicode 172) as a separator for a particular set of data. But this character doesn't format correctly in excel after the spool.
I still have access to both machines; and from testing between the two, I'm finding that the spool defaults to UTF-8, but when the "¬" is found is changes to ANSI.
But on my new machine it just always outputs to UTF-8, which is causing formatting problems when opened in excel.
I'm a bit stuck as to what to do about this? Any guidence would be appriecated
Thanks