Unicode script problem
Brian Donahue
Posts: 6,590 Bronze 1
Hi Andy,
It looks like a problem with Query Analyzer -- I've tried setting the
text options to Unicode, OEM, and ANSI, and the superflous characters don't
go away.
You can open the file in Notepad just fine, though. You can even copy
from Notepad and paste into QA with no ill-effects, which is kind of
strange.
I think that this might have something to do with the UTF-8 preamble
being removed from the front of the output files. The trouble is that we had
lots of requests to change the UTF-8 format to the way it is now.
Regards,
Brian Donahue
Red Gate Technical Support
"Andy Langridge" <Andy@bigskip.co.uk> wrote in message
news:33eODX5JEHA.1240@server53...
> Hi there
>
> I have a database that includes characters such as £ and ² - the script
> produced seems to like adding  in front of these - any thoughts???
>
> Andy
>
>
It looks like a problem with Query Analyzer -- I've tried setting the
text options to Unicode, OEM, and ANSI, and the superflous characters don't
go away.
You can open the file in Notepad just fine, though. You can even copy
from Notepad and paste into QA with no ill-effects, which is kind of
strange.
I think that this might have something to do with the UTF-8 preamble
being removed from the front of the output files. The trouble is that we had
lots of requests to change the UTF-8 format to the way it is now.
Regards,
Brian Donahue
Red Gate Technical Support
"Andy Langridge" <Andy@bigskip.co.uk> wrote in message
news:33eODX5JEHA.1240@server53...
> Hi there
>
> I have a database that includes characters such as £ and ² - the script
> produced seems to like adding  in front of these - any thoughts???
>
> Andy
>
>
This discussion has been closed.
