Home » Developer & Programmer » Forms » Mathematical symbols
Mathematical symbols [message #387837] Fri, 20 February 2009 15:32 Go to next message
Annel
Messages: 4
Registered: February 2009
Location: Pakistan
Junior Member
Hello Everone!
I have inserted mathematical symbols e.g. quare root,pie
etc etc. But when I come to query them they are represent by '?'
mark.
Anyone know please do tell me.

regards
Re: Mathematical symbols [message #388253 is a reply to message #387837] Tue, 24 February 2009 00:51 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Can you see these characters via SQL*Plus?

Research 'NLS_LANG'.

David
Re: Mathematical symbols [message #389213 is a reply to message #388253] Fri, 27 February 2009 11:24 Go to previous messageGo to next message
Annel
Messages: 4
Registered: February 2009
Location: Pakistan
Junior Member
No, B'cuz i had loaded them all through odbc connection between oracle and msaccess databases.
Re: Mathematical symbols [message #389892 is a reply to message #389213] Wed, 04 March 2009 00:09 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
If they are appearing as '?' in SQL*Plus then try different settings of 'nls_lang'. You may need to be using 'utl8' or something like that.

David
Re: Mathematical symbols [message #521993 is a reply to message #389892] Mon, 05 September 2011 06:03 Go to previous messageGo to next message
itech
Messages: 168
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

djmartin wrote on Wed, 04 March 2009 11:09
If they are appearing as '?' in SQL*Plus then try different settings of 'nls_lang'. You may need to be using 'utl8' or something like that.

David


u mean 'utf8' instead 'utl8' ???
Re: Mathematical symbols [message #521997 is a reply to message #521993] Mon, 05 September 2011 06:20 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Most probably; only, don't expect David to answer your question(s) as he doesn't visit this forum any more.
Previous Topic: Applying Serial No in detail block
Next Topic: How to clear line records when F11 is pressed in header block
Goto Forum:
  


Current Time: Thu Dec 08 22:20:34 CST 2016

Total time taken to generate the page: 0.08827 seconds