<i id='r4Eyl'><tr id='r4Eyl'><dt id='r4Eyl'><q id='r4Eyl'><span id='r4Eyl'><b id='r4Eyl'><form id='r4Eyl'><ins id='r4Eyl'></ins><ul id='r4Eyl'></ul><sub id='r4Eyl'></sub></form><legend id='r4Eyl'></legend><bdo id='r4Eyl'><pre id='r4Eyl'><center id='r4Eyl'></center></pre></bdo></b><th id='r4Eyl'></th></span></q></dt></tr></i><div id='r4Eyl'><tfoot id='r4Eyl'></tfoot><dl id='r4Eyl'><fieldset id='r4Eyl'></fieldset></dl></div>
<tfoot id='r4Eyl'></tfoot>
  • <legend id='r4Eyl'><style id='r4Eyl'><dir id='r4Eyl'><q id='r4Eyl'></q></dir></style></legend>
  • <small id='r4Eyl'></small><noframes id='r4Eyl'>

      <bdo id='r4Eyl'></bdo><ul id='r4Eyl'></ul>

      1. 如何添加xml编码<?xml version="1.0"编码=“UTF-8"?>

        时间:2023-10-10
      2. <tfoot id='8gsF8'></tfoot>

        <small id='8gsF8'></small><noframes id='8gsF8'>

          <tbody id='8gsF8'></tbody>
        <legend id='8gsF8'><style id='8gsF8'><dir id='8gsF8'><q id='8gsF8'></q></dir></style></legend>

              • <bdo id='8gsF8'></bdo><ul id='8gsF8'></ul>
                <i id='8gsF8'><tr id='8gsF8'><dt id='8gsF8'><q id='8gsF8'><span id='8gsF8'><b id='8gsF8'><form id='8gsF8'><ins id='8gsF8'></ins><ul id='8gsF8'></ul><sub id='8gsF8'></sub></form><legend id='8gsF8'></legend><bdo id='8gsF8'><pre id='8gsF8'><center id='8gsF8'></center></pre></bdo></b><th id='8gsF8'></th></span></q></dt></tr></i><div id='8gsF8'><tfoot id='8gsF8'></tfoot><dl id='8gsF8'><fieldset id='8gsF8'></fieldset></dl></div>
                • 本文介绍了如何添加xml编码<?xml version="1.0"编码=“UTF-8"?>到 SQL Server 中的 xml 输出的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  可能是未答复的副本.SQL Server 2008 - 向 XML 输出添加 XML 声明

                  如果可能,请告诉我.我在一些博客中读到

                  Please let me know if this is possible. I read in some blogs

                  http://forums.asp.net/t/1455808.aspx/1

                  http://www.devnewsgroups.net/group/microsoft.public.sqlserver.xml/topic60022.aspx

                  但我不明白为什么我不能这样做.

                  But I couldn't understand why I can't do this.

                  推荐答案

                  您必须手动添加它.SQL Server 总是在内部将 xml 存储为 ucs-2,因此 SQL 不可能将其生成为 utf-8 编码标头

                  You have to add it manually. SQL Server always stores xml internally as ucs-2 so it is impossible for SQL to generate it a utf-8 encoding header

                  请参阅 xml 数据类型的限制" 在 MSDN 上

                  See "Limitations of the xml Data Type" on MSDN

                  将 XML 数据存储在 xml 数据类型实例中时,不会保留 XML 声明 PI,例如 <?xml version='1.0'?>.这是设计使然.数据转换为 xml 类型后,XML 声明()及其属性(版本/编码/独立)丢失.XML 声明被视为 XML 解析器的指令.XML 数据在内部存储为 ucs-2.

                  The XML declaration PI, for example, <?xml version='1.0'?>, is not preserved when storing XML data in an xml data type instance. This is by design. The XML declaration (<?xml ... ?>) and its attributes (version/encoding/stand-alone) are lost after data is converted to type xml. The XML declaration is treated as a directive to the XML parser. The XML data is stored internally as ucs-2.

                  这篇关于如何添加xml编码<?xml version="1.0"编码=“UTF-8"?>到 SQL Server 中的 xml 输出的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  上一篇:插入表时出现错误,而不是来自实体数据框架的触发器 下一篇:转置没有聚合的行和列

                  相关文章

                    <tfoot id='1Yumk'></tfoot>
                  1. <i id='1Yumk'><tr id='1Yumk'><dt id='1Yumk'><q id='1Yumk'><span id='1Yumk'><b id='1Yumk'><form id='1Yumk'><ins id='1Yumk'></ins><ul id='1Yumk'></ul><sub id='1Yumk'></sub></form><legend id='1Yumk'></legend><bdo id='1Yumk'><pre id='1Yumk'><center id='1Yumk'></center></pre></bdo></b><th id='1Yumk'></th></span></q></dt></tr></i><div id='1Yumk'><tfoot id='1Yumk'></tfoot><dl id='1Yumk'><fieldset id='1Yumk'></fieldset></dl></div>

                    <small id='1Yumk'></small><noframes id='1Yumk'>

                      <bdo id='1Yumk'></bdo><ul id='1Yumk'></ul>

                      <legend id='1Yumk'><style id='1Yumk'><dir id='1Yumk'><q id='1Yumk'></q></dir></style></legend>