Home » Developer & Programmer » Reports & Discoverer » How to find out the character set (Oracle 9i, forms 6i)
How to find out the character set [message #325652] Sat, 07 June 2008 03:42 Go to next message
dillango
Messages: 145
Registered: January 2008
Senior Member
Hi,

While findout the solution for arabic printing in Reports, I have been asked to check the database installed which character set.
I don't know to findout this. Can anybody suggest please?

My problem is, In forms I am accepting arabic text (I changed the text font as "Arabic Transparent") and storing into the database. I have no problem while querying through sql plus, or to view from forms. But when I try to print through Reports, it is printing some junk characters.

I have gone through all clues provided in this forms but I still yet to find the right solution.

Ilango

Re: How to find out the character set [message #325654 is a reply to message #325652] Sat, 07 June 2008 04:13 Go to previous messageGo to next message
pxgupta2k
Messages: 2
Registered: April 2005
Location: Bangalore
Junior Member
Hi,

Use below query to findout DB characterset.

column name format a25
column VALUE$ format a35

SELECT name,value$ FROM sys.props$;

Thanks
Pankaj
Re: How to find out the character set [message #327147 is a reply to message #325654] Sat, 14 June 2008 04:49 Go to previous message
dillango
Messages: 145
Registered: January 2008
Senior Member
Thank you Mr.Pankaj,

Your query was very useful.

Ilango
Previous Topic: Combining two fields
Next Topic: Error ora-00918
Goto Forum:
  


Current Time: Wed May 15 13:35:11 CDT 2024