File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Insert Unicode character Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Insert Unicode character" Watch "Insert Unicode character" New topic
Author

Insert Unicode character

smitha rai
Ranch Hand

Joined: Aug 15, 2001
Posts: 33
Hi,
I have a PL-SQL function that returns a string. The return string contains two strings separated by a unicode character (example AA�BB). My code returns AB\u00fdBB instead of AA�BB. How to insert a unicode character in PLSQL? My code is as under. M
Appreciate if some one helps me out in this regard.
Thanks in advance,
Smitha
============================================================================
FUNCTION getValue(strA VARCHAR2, strB VARCHAR2)RETURN VARCHAR2
AS
v_unicode VARCHAR2(10) := '\u00fd';
v_out VARCHAR2(50);
BEGIN
v_out strA || v_unicode || strB;
DBMS_OUTPUT.PUT_LINE(v_out);
RETURN v_out;
END getValue;
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61434
    
  67

smitha,
You have been asked at least once (in this topic) to change your diplay name to comply with JavaRanch standards.
Please take a look at the JavaRanch Naming Policy and change your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.
Please change your display name before your next post.
Thanks!
bear
JDBC/JSP Forum Bartender


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
 
jQuery in Action, 2nd edition
 
subject: Insert Unicode character