What is diff in Open SQl and Unicode

[Former Member]

Hi.

What is difference in Open SQl and Unicode.

What are advantages of Unicode ?

[Former Member]

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.

[Former Member]

Could you please tell me more information about Unicode?

[Former Member]

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

[Former Member]

hi osk,

<b>u cant compare open sql with unicode as both are different..</b>

just a small explanation..

<b>Open SQL</b> 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

<b>unicode</b>

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

<b>please close the thread after rewarding the appropriate points...</b>

Message was edited by: Ashok Kumar Prithiviraj