<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic DB-Select from external Oracle-DB: Codepage conversion in Application Development and Automation Discussions</title>
    <link>https://community.sap.com/t5/application-development-and-automation-discussions/db-select-from-external-oracle-db-codepage-conversion/m-p/1935699#M387018</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;I try to get data from an external Oracle-DB which runs under NLS_CHARACTER&lt;/P&gt;&lt;P&gt;WE8ISO8859P1. In this DB are russian texte stored. If I read these texts via native-SQL I obviously get wrong characters. (e.g. Èíñòðóìåíòû äëÿ óãëîâîé øëèôîâàëüíîé ìàøèíû instead of &amp;amp;#1048;&amp;amp;#1085;&amp;amp;#1089;&amp;amp;#1090;&amp;amp;#1088;&amp;amp;#1091;&amp;amp;#1084;&amp;amp;#1077;&amp;amp;#1085;&amp;amp;#1090;&amp;amp;#1099; &amp;amp;#1076;&amp;amp;#1083;&amp;amp;#1103; &amp;amp;#1091;&amp;amp;#1075;&amp;amp;#1083;&amp;amp;#1086;&amp;amp;#1074;&amp;amp;#1086;&amp;amp;#1081; &amp;amp;#1096;&amp;amp;#1083;&amp;amp;#1080;&amp;amp;#1092;&amp;amp;#1086;&amp;amp;#1074;&amp;amp;#1072;&amp;amp;#1083;&amp;amp;#1100;&amp;amp;#1085;&amp;amp;#1086;&amp;amp;#1081; &amp;amp;#1084;&amp;amp;#1072;&amp;amp;#1096;&amp;amp;#1080;&amp;amp;#1085;&amp;amp;#1099;). If I save the text as a html file and then open it with IE. I can change the encoding and get the right view.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Has anybody got an idea ? (Mabye I can read the data in a different codepage or maybe there is a possibility to convert the codepage in SAP after reading it from oracle)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks a lot !!!!&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 06 Feb 2007 19:19:48 GMT</pubDate>
    <dc:creator>former_member246510</dc:creator>
    <dc:date>2007-02-06T19:19:48Z</dc:date>
    <item>
      <title>DB-Select from external Oracle-DB: Codepage conversion</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/db-select-from-external-oracle-db-codepage-conversion/m-p/1935699#M387018</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;I try to get data from an external Oracle-DB which runs under NLS_CHARACTER&lt;/P&gt;&lt;P&gt;WE8ISO8859P1. In this DB are russian texte stored. If I read these texts via native-SQL I obviously get wrong characters. (e.g. Èíñòðóìåíòû äëÿ óãëîâîé øëèôîâàëüíîé ìàøèíû instead of &amp;amp;#1048;&amp;amp;#1085;&amp;amp;#1089;&amp;amp;#1090;&amp;amp;#1088;&amp;amp;#1091;&amp;amp;#1084;&amp;amp;#1077;&amp;amp;#1085;&amp;amp;#1090;&amp;amp;#1099; &amp;amp;#1076;&amp;amp;#1083;&amp;amp;#1103; &amp;amp;#1091;&amp;amp;#1075;&amp;amp;#1083;&amp;amp;#1086;&amp;amp;#1074;&amp;amp;#1086;&amp;amp;#1081; &amp;amp;#1096;&amp;amp;#1083;&amp;amp;#1080;&amp;amp;#1092;&amp;amp;#1086;&amp;amp;#1074;&amp;amp;#1072;&amp;amp;#1083;&amp;amp;#1100;&amp;amp;#1085;&amp;amp;#1086;&amp;amp;#1081; &amp;amp;#1084;&amp;amp;#1072;&amp;amp;#1096;&amp;amp;#1080;&amp;amp;#1085;&amp;amp;#1099;). If I save the text as a html file and then open it with IE. I can change the encoding and get the right view.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Has anybody got an idea ? (Mabye I can read the data in a different codepage or maybe there is a possibility to convert the codepage in SAP after reading it from oracle)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks a lot !!!!&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 06 Feb 2007 19:19:48 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/db-select-from-external-oracle-db-codepage-conversion/m-p/1935699#M387018</guid>
      <dc:creator>former_member246510</dc:creator>
      <dc:date>2007-02-06T19:19:48Z</dc:date>
    </item>
    <item>
      <title>Re: DB-Select from external Oracle-DB: Codepage conversion</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/db-select-from-external-oracle-db-codepage-conversion/m-p/1935700#M387019</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;try abap command "translate" and table TCP00 &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;A.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 07 Feb 2007 07:29:46 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/db-select-from-external-oracle-db-codepage-conversion/m-p/1935700#M387019</guid>
      <dc:creator>andreas_mann3</dc:creator>
      <dc:date>2007-02-07T07:29:46Z</dc:date>
    </item>
    <item>
      <title>Re: DB-Select from external Oracle-DB: Codepage conversion</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/db-select-from-external-oracle-db-codepage-conversion/m-p/1935701#M387020</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;The problem is solved.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks !&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 22 Sep 2011 07:09:52 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/db-select-from-external-oracle-db-codepage-conversion/m-p/1935701#M387020</guid>
      <dc:creator>former_member246510</dc:creator>
      <dc:date>2011-09-22T07:09:52Z</dc:date>
    </item>
  </channel>
</rss>

