Member Avatar for harinath_2007

Hi all ,

Here comes the same general question.
I want to store the text ( you can call 'paragraphs' ) . What is the best way to do that? Files?
OR database is OK?

Thanks in advance :)

  • 2 Contributors
  • 7 Replies
  • 199 Views
  • 5 Hours Discussion Span
  • Latest Post Latest Post by harinath_2007
Member Avatar for pritaeas

Both are possible. It depends on what you are planning to do with them, that should guide you to the right choice.

Member Avatar for harinath_2007

@pritaeas...Thanks for the reply

I just want to store and retreive whenever i want. I dont want to manipulate the text. Just want to retreive and store with ease.
I thought of files But when i look at their down side , It is not flexible if i want to retrieve the random part of the text or paragraph.
So i am looking for different ways of storing paragraphs in database.
Is there any other EFFICIENT OR CORRECT OR POSSIBLE way of storing text other than that INSERT command?

SO , lets say if i want to store some paragraph with 4 lines.
What i do is (What i know is )

insert into mytable(' paragraph goes here ');

Just thinking that it will be complicated to insert some multiple lines of text through that insert command.

Is there any other way?.

Thanks

Member Avatar for pritaeas

Are you going to insert those through the command line of the database, or are you going to use a client/front-end? If it's the first, then yes, it works, but may be tricky, especially if your text contains quotes. If you are using a front-end then all of that is taken care of for you. For example: I use Navicat as my database client.

Member Avatar for harinath_2007

I want to insert through command line as of now (maybe i will find some time and learn about how to use Navicat later).And my text contains quotes . That is the reason , i havent started inserting those paragraphs into my database yet untill i find a better and easy solution for that.

Edited by harinath_2007
Member Avatar for harinath_2007

How about using oracle 11g where i can directly paste my paragraphs into database through GUI without worrying about those quotes and writing the queries?.

Edited by harinath_2007
Member Avatar for harinath_2007

yeah...:) Then that should solve my requirements. I will try Navicat too if i find some time. Thanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.