Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\sqlserv.15.07.html
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <!-- MOTW-DISABLED saved from url=(0014)about:internet --> <title>Unicode Support</title> <link rel="StyleSheet" href="css/sqlserv.css" type="text/css" media="all" /> <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" /> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/context.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/towwhdir.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/wwhpagef.js"></script> <script type="text/javascript" language="JavaScript1.2"> <!-- var WebWorksRootPath = ""; // --> </script> <script type="text/javascript" language="JavaScript1.2"> <!-- // Set reference to top level help frame // var WWHFrame = WWHGetWWHFrame("", true); // --> </script> <script type="text/javascript" language="JavaScript1.2" src="scripts/expand.js"></script> </head> <body class="" style="background-color: #FFFFEE;" onload="WWHUpdate();" onunload="WWHUnload();" onkeydown="WWHHandleKeyDown((document.all||document.getElementById||document.layers)?event:null);" onkeypress="WWHHandleKeyPress((document.all||document.getElementById||document.layers)?event:null);" onkeyup="WWHHandleKeyUp((document.all||document.getElementById||document.layers)?event:null);"> <br /> <div class="WebWorks_Breadcrumbs" style="text-align: left;"> <a class="WebWorks_Breadcrumb_Link" href="sqlserv.15.01.html#181137">11 The SQL Server Wire Protocol Driver</a> : Unicode Support</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="181137">Unicode Support</a></div> <div class="Body"><a name="181138">The SQL Server Wire Protocol driver maps the Microsoft SQL Server data types to Unicode </a>data types as shown in the following table:</div> <table class="Format_B" cellspacing="0" summary=""> <caption></caption> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="181141">SQL Server Data Type</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="181143">Mapped to. . .</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="181151">datetimeoffset <sup><a name="wwfootnote_inline_61" href="#61">1</a></sup></a><span class="superscript"> </span><sup><a name="wwfootnote_inline_62" href="#62">2</a></sup></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="181153">SQL_WVARCHAR</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="181155">nchar</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="181157">SQL_WCHAR</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="181159">ntext</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="181161">SQL_WLONGVARCHAR</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="181163">nvarchar</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="181165">SQL_WVARCHAR</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="181167">nvarchar(max) </a><span class="superscript" style="color: #0000ff;"><a href="javascript:WWHClickedPopup('ODBC', 'sqlserv.15.07.html#181151', '');">1</a></span></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="181169">SQL_WLONGVARCHAR</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="181171">sysname</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="181173">SQL_WVARCHAR</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="181175">xml </a><span class="superscript" style="color: #0000ff;"><a href="javascript:WWHClickedPopup('ODBC', 'sqlserv.15.07.html#181151', '');">1</a></span></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="181177">SQL_WLONGVARCHAR</a></div> </td> </tr> </table> <hr /> <div style="font-family: Arial; font-size: 8pt; float: left; padding-right: 10px;"> <a name="61" href="#wwfootnote_inline_61">1</a> </div> <div class="TableFootnote"><a name="181147">Supported only for Microsoft SQL Server 2008.</a></div> <br style="clear: all;" /> <div style="font-family: Arial; font-size: 8pt; float: left; padding-right: 10px;"> <a name="62" href="#wwfootnote_inline_62">2</a> </div> <div class="TableFootnote"><a name="181150">Datetimeoffset mapping changes based on the setting of the Fetch TSWTZ as Timestamp option.</a></div> <br style="clear: all;" /> <div class="Body"><a name="289052">The driver supports the Unicode ODBC W (Wide) function calls, such as SQLConnectW. </a>This allows the Driver Manager to transmit these calls directly to the driver. Otherwise, the Driver Manager would incur the additional overhead of converting the W calls to ANSI function calls, and vice versa.</div> <div class="Body"><a name="289057">See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'unixenv.07.9.html#107448', '');">â??UTF-16 Applications on UNIX and Linuxâ??</a></span> for related details. Also, refer to <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'unicode.06.1.html#106144', '');">Chapter 4 â??Internationalization, Localization, and Unicodeâ??</a></span> in the <span class="Emphasis">DataDirect Connect Series </span><span class="forbody">for</span> <span class="Emphasis" style="font-size: 8.0pt;">ODBC</span><span class="Emphasis" style="font-size: 10.0pt;"> </span><span class="Emphasis" style="font-size: 10.0pt;">Reference</span> for a more detailed explanation of Unicode.</div> <div class="head_2"><a name="233788">Using the XML Data Type</a></div> <div class="Body"><a name="233789">By default, Microsoft SQL Server returns XML data to the driver encoded as UTF-8. To </a>avoid data loss, an application must bind XML data as SQL_C_WCHAR. The driver then returns the data as either UTF-8 or UTF-16, depending on platform and application settings. If the application binds XML data as SQL_C_CHAR, the driver converts it to the client character encoding, possibly causing data loss or corruption. To prevent any conversion of XML data, the application must set the attribute <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'sqlserv.15.04.html#180882', '');">XML Describe Type</a></span> to SQL_LONGVARBINARY (-10) and bind the data as SQL_C_BINARY.</div> <script type="text/javascript" language="JavaScript1.2"> <!-- // Clear related topics // WWHClearRelatedTopics(); document.writeln(WWHRelatedTopicsInlineHTML()); // --> </script> </blockquote> <script type="text/javascript" language="JavaScript1.2"> <!-- document.write(WWHRelatedTopicsDivTag() + WWHPopupDivTag() + WWHALinksDivTag()); // --> </script> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de