Home

Forums

Web development

 

 

 

 
     
 
dna88 Web development and Technology Forum
 
Profile   Register   Memberlist   Usergroups   FAQ   Search  Log in
Best way to store long text in mysql?

 
Post new topic   Reply to topic    dna88 Forum Index -> Databases Discussion Forum
Author Message
quantum
Site Admin
Site Admin


Joined: 07 Mar 2004
Posts: 1048
Location: Dhaka, Bangladesh

Post Post subject: Best way to store long text in mysql? Reply with quote

I was wondering what would be the best and optimized way to store very large amount of data in a mysql database? Like may be a very long article or story. It may also have to handle text with html formatting. Anyone worked with large amount of text and Mysql before?
_________________

Dust fills my eyes / Clouds roll by / and I roll with them / Centuries cry / Orders fly / and I fall again
Afford best design, implement best solution. Outsource your web design.
Sun Aug 29, 04 6:22 am
Back to top
quantum View user's profile Send private message Visit poster's website AIM Address
hasnut
Expert User
Expert User


Joined: 28 Aug 2004
Posts: 201

Post Post subject: Reply with quote

yes you can store with html tags. Its perfectly handels.
you can use MEDIUMTEXT,LONGTEXT or all BLOB types datatypes.

the size of datatype (maybe you know it)
but also here you can see the sizes of datatype
http://dev.mysql.com/tech-resources/articles/visual-basic-datatypes.html
IF you need specfic problem let me know?
_________________
Sarder Hasnut
MCSD, CIW A

Need Low Cost Prefessional Hosting Contact me
Mon Aug 30, 04 9:34 am
Back to top
hasnut View user's profile Send private message Visit poster's website MSN Messenger
quantum
Site Admin
Site Admin


Joined: 07 Mar 2004
Posts: 1048
Location: Dhaka, Bangladesh

Post Post subject: Large text with mysql Reply with quote

Thanks hasnut. I see that TExT field can hold upto 65535 chracters. So that's quite enough for most requirements . I don't have any specific problem in hand. I was just wondering about others' preferences. And if there were any specific advantages on the available options.
_________________

Dust fills my eyes / Clouds roll by / and I roll with them / Centuries cry / Orders fly / and I fall again
Afford best design, implement best solution. Outsource your web design.
Mon Aug 30, 04 10:23 am
Back to top
quantum View user's profile Send private message Visit poster's website AIM Address
Display posts from previous:   
Post new topic   Reply to topic    dna88 Forum Index -> Databases Discussion Forum All times are GMT - 7 Hours
Page 1 of 1

 

Partners and Resources

Bangladesh hosting company

Bangladesh web design

Driven by phpBB © phpBB Group