[opencms-dev] BLOB and text

[Joe Desbonnet]

I normally use the 'text' datatype for that. If the article is plain
text the java.lang.String should be perfect. If the article is stored
in XML, then depending on what sort of pre-processing you want to do,
a DOM structure might be more appropriate.

Be mindful of character encoding (ISO-8859-1 vs UTF-8) -- if your non
US-ASCII characters are corrupted on save/restore it's probably a
character encoding problem.

You will find a full manual for MySQL in the Developers area at
http://www.mysql.com/

Joe.


On 6/24/05, Saeed Meerkhan <saeed.me at gmail.com> wrote:
> If i want to save a big amount of text (an article...) in a MySql
> database. What would be the best type of data to store it in? . And
> when I will get this content in JSP pages, what would be an
> appropriate Hava data type to store it in?
> 
> Thanks
> --
> 
> 
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
>