Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

unicode

Go to solution
Former Member

‎2007 Jul 06 8:35 AM

0 Likes
518

hi.....

what are the general unicode errors?

1 ACCEPTED SOLUTION
3 REPLIES 3
Read only

Go to solution
Former Member

‎2007 Jul 06 8:40 AM

0 Likes
494

Hi,

plz go through the following thread.....

****do reward if usefull

vijay

Read only

Go to solution
Former Member

‎2007 Jul 06 8:48 AM

0 Likes
494

Hi Soumya,

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

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

<b>problems during a database update (during the catalog migration</b>)

<b>problems with passwords (e.g. during connect using the DBSL)</b>

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

<b>problems with data types </b>

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.

<i>if found usefull reward pts</i>

Regards

Sathish:)