Home » Developer & Programmer » Forms » Not able to display characters (10g Application Server win xp)
Not able to display characters [message #341298] Mon, 18 August 2008 04:23 Go to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Hi,

I am creating form that will print resumes of candidates. I have created a table (RESUMES) which will store the candidate name and their resume in the database.

The attached form (character_display.gif) displays one record of the table. As seen the name column (varchar2(50)) displays the name 'Durgadas' but the resume column (clob) does not display the characters properly.

What changes can I inculcate to display the resume in the form so that I can make it print in the word file later?
Re: Not able to display characters [message #341333 is a reply to message #341298] Mon, 18 August 2008 07:07 Go to previous messageGo to next message
mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait
Senior Member

Did you query the database to see what is stored on it? you may need to change some properties in the regional settings of the OS if you are using multi language.
Re: Not able to display characters [message #341352 is a reply to message #341333] Mon, 18 August 2008 08:44 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Thanks for the reply..

It is not a problem of the database but of the form..Here is the table from the sqlplus

SQL> desc resumes
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 NAME                                               VARCHAR2(30)
 RESUME                                             CLOB

SQL> select * from resumes;

NAME
------------------------------
RESUME
--------------------------------------------------------------------------------

Durgadas
╨╧◄α▒→                > ♥ ■   ♠           ☻   ƒ        ►     ☺   ■    



As you can see the resumes column will not display properly as it is a clob column..so I tried to display the same from the form but still the resume did not show the way it can be seen in the word document. It is still displays the same off characters and signs that it shows here..basically the form is not able to interpret its data type. to add to this I also tried doing the same with BLOB datatype in the resume column but the result was the same. Would you know how to display an object stored in the database in the clob/blob data type in its normal form especially is it was a word document.

Re: Not able to display characters [message #341356 is a reply to message #341352] Mon, 18 August 2008 09:23 Go to previous message
mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait
Senior Member

You could look at these links

http://forums.oracle.com/forums/message.jspa?messageID=936088

http://forums.oracle.com/forums/thread.jspa?threadID=378781&tstart=0&messageID=1272020

Let me know if you find any other solutions.

Mudabbir
Previous Topic: Hardware Inventory
Next Topic: how to go for a spcified record in a block
Goto Forum:
  


Current Time: Tue Dec 06 04:37:20 CST 2016

Total time taken to generate the page: 0.14286 seconds