Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\oraclecli.17.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/oraclecli.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="oraclecli.17.01.html#559048">13 The Oracle Driver </a> : Unicode Support</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="559048">Unicode Support</a></div> <div class="Body"><a name="559049">The Oracle driver uses the NLS_LANG environment variable setting of the Oracle client to </a>determine how to transmit data to the client.</div> <div class="Body"><a name="559050">On Windows, UNIX, and Linux, a Unicode setting is determined if the NLS_LANG </a>environment variable is set to:</div> <div class="Body"><span class="Emphasis"><a name="559051">LANGUAGE</a></span>_<span class="Emphasis">TERRITORY</span>.<span class="Emphasis">CHARSET</span></div> <div class="Body"><a name="559052">where </a><span class="Emphasis">CHARSET</span> is either UTF8, AL24UTFFSS, or AL32UTF8. For example:</div> <div class="Body"><a name="559053">AMERICAN_AMERICA.UTF8</a></div> <div class="Body"><a name="559054">Alternatively, on Windows, instead of the NLS_LANG environment variable, the value of the </a><span class="Syntax">HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\</span><span class="EquationVariables">oracle_home_key</span> registry key can be set to:</div> <div class="Body"><span class="Emphasis"><a name="559055">LANGUAGE</a></span>_<span class="Emphasis">TERRITORY</span>.<span class="Emphasis">CHARSET</span></div> <div class="Body"><a name="559056">where </a><span class="EquationVariables">oracle_home_key</span> is HOME0 for Oracle 9<span class="Emphasis">i</span> R2 and earlier, and is the Oracle home name used at the time of client installation for Oracle 10<span class="Emphasis">g</span>.</div> <div class="Body"><a name="559057">If the </a><span class="Emphasis">CHARSET</span> is a Unicode setting and a Unicode application is accessing the driver, then no data conversion is necessary. If an ANSI application is accessing the driver, then the driver must convert the data from the application from ANSI to Unicode (UTF-8) for the client.</div> <div class="Body"><a name="559058">If the </a><span class="Emphasis">CHARSET</span> is ANSI and an ANSI application is accessing the driver, then no data conversion is necessary. If a Unicode application is accessing the driver, then the driver must convert the data from the application from Unicode to ANSI for the client. </div> <div class="Body"><a name="559059">If NLS_LANG is set to UTF-8, the Oracle driver maps the Oracle data types to Unicode data </a>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="559062">Oracle 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="559064">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="559066">CHAR</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="559068">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="559070">CLOB</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="559072">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="559074">VARCHAR2</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="559076">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="559078">LONG</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="559080">SQL_WLONGVARCHAR</a></div> </td> </tr> </table> <div class="Body"><a name="559082">The driver also continues to map these Oracle data types to the normal character data </a>types. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'oraclecli.17.06.html#558854', '');">â??Data Typesâ??</a></span> for these mappings.</div> <div class="Body"><a name="608821">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="608826">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> <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