How to register a Clob in the dataBase

[Glen D'cruz]

Hai Everyone,
I want to register a Clob in the database, can any give me an example as to how to go about this.
What I mean is just as we create a table in the database, how do you create a clob.
I frequently get an error message stating "File not found"
Thanks to all

[Jeanne Boyarsky]

Glen,
You can add a clob to a column of a table. I don't know of anyway of just adding a clob.

[Glen D'cruz]

Hai Jeanne,
Thanks for your reply. Can you give me an example. The table only accepts int, float, string, but not Clobs. I tried it , but it did not work.

[Jeanne Boyarsky]

Glen,
When you create the table, you need to create a column with a clob type. This is a bit database specific. What database are you using?

[Glen D'cruz]

Hai Jeanne,
I am using SQLServer, and haven't still figured out a way of doing it.
I will place the whole program for your crutinity on the web this weekend so go through it and modify it if required.
Once again thanks for your time and effort.
[ July 08, 2004: Message edited by: Glen D'cruz ]

[Glen D'cruz]

Jeanne,
I have fixed the problem. I used a varchar as the dataType instead of text. The database has accepted it and saved it. I have now to design
a program to retreive the clob.
Thanks once again.