Home » SQL & PL/SQL » SQL & PL/SQL » database converting pound sign £ to #
database converting pound sign £ to # [message #392835] Thu, 19 March 2009 08:08 Go to next message
r_junior
Messages: 3
Registered: March 2009
Junior Member
hi ,
I am seding an email throgh a routine written in databse by using utl_smtp my email had pound sign in it £ but when displaying it is showing # sign instead of pound what could be possibly going wrong in it.
thanks
Re: database converting pound sign £ to # [message #392842 is a reply to message #392835] Thu, 19 March 2009 08:19 Go to previous messageGo to next message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
When I walked into a building I was wearing red socks. When I walked out, my hair had changed colour. What on earth could have happened?
Re: database converting pound sign £ to # [message #392998 is a reply to message #392842] Thu, 19 March 2009 23:31 Go to previous messageGo to next message
r_junior
Messages: 3
Registered: March 2009
Junior Member
I don't understand the meaning of your reply
Re: database converting pound sign £ to # [message #393007 is a reply to message #392998] Fri, 20 March 2009 00:16 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
I don't understand the meaning of your reply


me too.

please post your code.or and read the orafaq forum guide lines
Re: database converting pound sign £ to # [message #393012 is a reply to message #392835] Fri, 20 March 2009 00:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
r_junior wrote on Thu, 19 March 2009 14:08
hi ,
I am seding an email throgh a routine written in databse by using utl_smtp my email had pound sign in it £ but when displaying it is showing # sign instead of pound what could be possibly going wrong in it.
thanks

NLS/locale parameters.

Regards
Michel

Re: database converting pound sign £ to # [message #393021 is a reply to message #393012] Fri, 20 March 2009 00:53 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Isn't # also called the pound sign (in the US)? Maybe the database got confused..
Guess Michel is right then in assuming it's a Locale setting
/forum/fa/917/0/

[Updated on: Fri, 20 March 2009 00:54]

Report message to a moderator

Re: database converting pound sign £ to # [message #393073 is a reply to message #392998] Fri, 20 March 2009 04:25 Go to previous message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
r_junior wrote on Fri, 20 March 2009 04:31
I don't understand the meaning of your reply
My reply implies that you gave next to no information other than saying "Something happened that I didn't want, what has gone wrong"
Although it is likely that Michel's reply will point you towards the likely problem, it is also possible that something in your code is causing the issue. we can't tell because you gave no information
Previous Topic: Database Platform details
Next Topic: Table hierarchy
Goto Forum:
  


Current Time: Sat Feb 08 13:50:48 CST 2025