Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Insert Unicode character

 
smitha rai
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 64683
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic