OraFAQ Forum: SQL & PL/SQL » Inserting special characters

Home » SQL & PL/SQL » SQL & PL/SQL » Inserting special characters

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Inserting special characters [message #38769]

Mon, 13 May 2002 12:51

bill
Messages: 75
Registered: November 1999

Member

Hello Everyone,

I need to append special characters to certain strings when the string is inserted into a table. What I'm referring to are the symbols for copywrite, registered and trademark. For example, if I insert Microsoft, I want to add a registerd symbol to the end. The application inserting the data can't handle this. I'm thinking of using a trigger. Does this make since? Could someone give me an example of concatenating a string and a character code?

Thanks,
Bill

Report message to a moderator

Re: Inserting special characters [message #38770 is a reply to message #38769]

Mon, 13 May 2002 13:00

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

In the trigger (how you know which symbol to append is left to you <g>):

:new.column_name := :new.column_name || chr(169);  -- append copyright symbol

Report message to a moderator

Thank you! [message #38771 is a reply to message #38769]

Mon, 13 May 2002 13:21

bill
Messages: 75
Registered: November 1999

Member

Report message to a moderator

Previous Topic:	Execute Immediate
Next Topic:	Trigger Unhappy

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 16:18:00 CDT 2024