topic unicode in Application Development and Automation Discussions

unicode

Former Member — Fri, 06 Jul 2007 07:35:26 GMT

hi.....

what are the general unicode errors?

Re: unicode

Former Member — Fri, 06 Jul 2007 07:40:31 GMT

Hi,

plz go through the following thread.....

****do reward if usefull

vijay

Re: unicode

Former Member — Fri, 06 Jul 2007 07:41:44 GMT

see the links

The Link will be helpful to you.

Very good document:

http://www.doag.org/pub/docs/sig/sap/2004-03/Buhlinger_Maxi_Version.pdf

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d37d1ad9-0b01-0010-ed9f-bc3222312dd8

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/589d18d9-0b01-0010-ac8a-8a22852061a2

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f8e316d9-0b01-0010-8e95-829a58c1511a

Reward points for useful Answers

Regards

Anji

Re: unicode

Former Member — Fri, 06 Jul 2007 07:48:21 GMT

Hi Soumya,

In different situations problems can occur which are caused by the used codetype (UNICODE):

problems during the installation (is the codetype of database and application server set correctly?)

problems during a database update (during the catalog migration)

problems with passwords (e.g. during connect using the DBSL)

problems with parameters concerning the size of internal buffers (e.g. PACKET_SIZE) converting problems

problems with data types

Dependent on the error situation you need to check different files/traces. In case of installation or upgrade problems you should check the installation log files. In case of connect problems the corresponding developer traces should be checked. The database trace might also be useful in case the error occurs in the database.

If you work with a Unicode system and the files you read and write are Unicode, everything is quite safe. Problems arise when textual data is converted from Unicode to a non-Unicode character set: The data might contain characters which do not exist in the target character set. On the other hand, when textual data is converted from non-Unicode to Unicode, the typical problem is that the software assumes the data to be encoded in a code page different from the one which was actually used.

so u can use this fm

NLS_STRING_CONVERT_TO_SYS for all conversions of Hexadecimal values.

if found usefull reward pts

Regards

Sathish:)