| Not able to display characters [message #341298] |
Mon, 18 August 2008 04:23  |
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 #341352 is a reply to message #341333] |
Mon, 18 August 2008 08:44  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
