long formatted text in a field

[dbdummy]

Hi, i have spent the last couple of hours googling this...

 

I have pages that have quite a bit of css formatted text. multiple paragraphs, unordered lists, headlines, etc. I don't want to have to break this up, but cannot fine what I need to get the text into one field in the database...is this possible?

 

thanks

 

[micah1701]

not sure what you're asking, are you saying that its to much data to fit in a single field?

 

if so, just change the field type to something like "text" or "longtext" or "blob"  which don't require a set maximum length (unlike "varchar" or "char" which have a max of 255 characters)

[dbdummy]

not sure what you're asking, are you saying that its to much data to fit in a single field?

 

if so, just change the field type to something like "text" or "longtext" or "blob"  which don't require a set maximum length (unlike "varchar" or "char" which have a max of 255 characters)

 

no, i have text formatted in css. ie

 

<p><span class="finheader">Here is my Headline</span><br>
                                            <span class="protext">here is some 
                                            text. and here is an external <a href="../about/trainers.php">link</a> 
                                            blah blah blah.</span></p>
                                          <p class="protext">oh, and here is another 
                                            paragraph. with alot of blah blah 
                                            blah.</p>
                                          <ul>
                                            <li class="protext"> here is bullet 
                                              1 </li>
                                            <li class="protext">here is bullet 
                                              2 </li>
                                            <li class="protext">here is bullet 
                                              point number 3</li>
                                          </ul>
                                          <p class="section">and them some more 
                                            blah blah text. formatted in a different 
                                            css style. and i have pages of this 
                                            stuff. </p>

I don't want to break the text up, so what can mysql handle with the above formatted text. can i just copy that as is and paste into the mysql field? or do i need some preformatted something around the whole thing? or do I need to change the tags <p class="section"> etc. to some other type of code?

 

thanks

[micah1701]

nah, just copy/paste and dump the whole thing in a giant field.  shouldn't be a problem.