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

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Can you see these characters via SQL*Plus?

Research 'NLS_LANG'.

David

Report message to a moderator

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.

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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: 173
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' ???

Report message to a moderator

Re: Mathematical symbols [message #521997 is a reply to message #521993] Mon, 05 September 2011 06:20 Go to previous message
Littlefoot
Messages: 21826
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.

Report message to a moderator

Previous Topic: Applying Serial No in detail block
Next Topic: How to clear line records when F11 is pressed in header block
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 25 05:36:09 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.