• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

Insert Unicode character

 
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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;
 
Sheriff
Posts: 67756
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic