topic Re: What is diff in Open SQl and Unicode in Application Development and Automation Discussions

What is diff in Open SQl and Unicode

Former Member — Mon, 20 Mar 2006 12:04:14 GMT

Hi.

What is difference in Open SQl and Unicode.

What are advantages of Unicode ?

Re: What is diff in Open SQl and Unicode

Former Member — Mon, 20 Mar 2006 12:08:53 GMT

Osk,

These are two different things, you cannot compare them. Open SQL is to retrieve data from any database where Unicode is to support multi-lingual implemenations in chinese, Korean etc.

I think unicode kernels are 32 / 64 bit so that it has more security as well.

regards,

Ravi

Note: Please mark the answers as helpful if they help you.

Re: What is diff in Open SQl and Unicode

Former Member — Mon, 20 Mar 2006 12:13:04 GMT

Hi,

Check these links.

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/25/93761b262849699db03ad99023aeec/frameset.htm">Unicode and open sql</a>

<a href="http://help.sap.com/saphelp_me21sp2/helpdata/en/25/93761b262849699db03ad99023aeec/content.htm">Working with Unnicode</a>

Regards,

Raj

Re: What is diff in Open SQl and Unicode

Former Member — Mon, 20 Mar 2006 12:16:16 GMT

hi osk,

u cant compare open sql with unicode as both are different..

just a small explanation..

Open SQL consists of a set of ABAP statements that perform operations on the central database in the R/3 System. The results of the operations and any error messages are independent of the database system in use. Open SQL thus provides a uniform syntax and semantics for all of the database systems supported by SAP. ABAP programs that only use Open SQL statements will work in any R/3 System, regardless of the database system in use. Open SQL statements can only work with database tables that have been created in the ABAP Dictionary

unicode

Data types such as CHAR ASCII and CHAR EBCDIC are mainly suited to English and central European languages. With other character sets, a code attribute is usually used for these data types. This code attribute uses a different presentation code to ASCII and EBCDIC, even for internal storage in the database system. This causes problems if you want to access these database systems using a different character set, or if you want to exchange data between database systems with different character sets.

You can avoid these problems by using internal character coding in accordance with UNICODE. Internally, the UNICODE data is stored in UTF-16/UCS-2 format. In UTF-16/UCS-2 format, all characters are two bytes long.

SAP DB is able to display various presentation codes in UNICODE format

please close the thread after rewarding the appropriate points...

Message was edited by: Ashok Kumar Prithiviraj

Re: What is diff in Open SQl and Unicode

Former Member — Fri, 10 Oct 2008 12:02:26 GMT

Could you please tell me more information about Unicode?