store big message in a table

Forum Moderators: open

Message Too Old, No Replies

7:23 pm on Mar 13, 2007 (gmt 0)

I have a location table in mysql.

After querying the table, the results obtained should show the location details and also some landmark.

The landmarks is a sentence or a two.

Should I store the guidelines (landmark) in the location table?
How much maximum characters can I store?

Is there any other way to shore the landmark.

Thanks

7:44 pm on Mar 13, 2007 (gmt 0)

ok I see I can do it wiht blob Tinytext.

If there is any other method, please guide me .

7:46 pm on Mar 13, 2007 (gmt 0)

Use long text if you want to keep the option for even more text.

9:22 pm on Mar 13, 2007 (gmt 0)

thanks