Discussion:
SQL 2000 :: Which Flavor Unicode Is Used For Flat File Export?
(too old to reply)
msnews.microsoft.com
2009-04-21 14:08:28 UTC
Permalink
that my doubt, when I export a file using UNICODE for a third party tool, it
fails, if I open it with notepad and I save it as UTF-8, it works

so
- which flavor of unicode does SQL used ??
- is that possible to "force" it to UTF-8 ??

thanks in advance

(I try to search in google, no lack, the only thing I found, was somebody
asking the same like me without reply ...
http://www.bigresource.com/MS_SQL-What-flavor-Unicode-is-used-for-flat-file-export--L48ynMFm.html
Russell Fields
2009-04-21 14:25:09 UTC
Permalink
http://www.codeproject.com/KB/reporting-services/UnicodeInSQLServer.aspx?display=PrintAll&fid=475299&df=90&mpp=25&noise=3&sort=Position&view=Quick&select=2533598

This article was written about SQL Server 2000, but as I understand it, the
picture is not much changed in 2005/2008.

If you wish, you can vote to show your support for adding UTF-8 support
here:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=362867&wa=wsignin1.0

RLF
Post by msnews.microsoft.com
that my doubt, when I export a file using UNICODE for a third party tool,
it fails, if I open it with notepad and I save it as UTF-8, it works
so
- which flavor of unicode does SQL used ??
- is that possible to "force" it to UTF-8 ??
thanks in advance
(I try to search in google, no lack, the only thing I found, was somebody
asking the same like me without reply ...
http://www.bigresource.com/MS_SQL-What-flavor-Unicode-is-used-for-flat-file-export--L48ynMFm.html
msnews.microsoft.com
2009-04-23 09:13:35 UTC
Permalink
Thnaks you
I am not sure I feel better after knowing that I am not so alone in this
topic...
Post by Russell Fields
http://www.codeproject.com/KB/reporting-services/UnicodeInSQLServer.aspx?display=PrintAll&fid=475299&df=90&mpp=25&noise=3&sort=Position&view=Quick&select=2533598
This article was written about SQL Server 2000, but as I understand it,
the picture is not much changed in 2005/2008.
If you wish, you can vote to show your support for adding UTF-8 support
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=362867&wa=wsignin1.0
RLF
Post by msnews.microsoft.com
that my doubt, when I export a file using UNICODE for a third party tool,
it fails, if I open it with notepad and I save it as UTF-8, it works
so
- which flavor of unicode does SQL used ??
- is that possible to "force" it to UTF-8 ??
thanks in advance
(I try to search in google, no lack, the only thing I found, was somebody
asking the same like me without reply ...
http://www.bigresource.com/MS_SQL-What-flavor-Unicode-is-used-for-flat-file-export--L48ynMFm.html
Loading...