longtext

Trouble with CONCAT and Longtext

The SQL... UPDATE Threads t SET t.Content = ( SELECT GROUP_CONCAT(a.Content ORDER BY a.PageID SEPARATOR '<!-- pagebreak -->') FROM MSarticlepages a WHERE a.ArticleID = t.MSthreadID GROUP BY a.ArticleID ) As you can see it takes all of an article's pages (which are each stored as longtext in separate rows) and GROUP_CONCA...

JPA native query for LONGTEXT field in a MySQL view results in error

Hi, I have the following JPA SqlResultSetMapping: @SqlResultSetMappings({ @SqlResultSetMapping(name="GroupParticipantDTO", columns={ @ColumnResult(name="gpId"), @ColumnResult(name="gpRole"), // @ColumnResult(name="gpRemarks") } ) Which is used like this: StringBuilder sbQuer...

storing long text

what is the best way to store long texts (articles) in a database? it doesnt need to be searchable. i want to allow ppl to read the first chapter of every book in my bookstore. dumping it into a database field makes it difficult to style paragraphs using css.. EDIT: access database ...

I'm taking the contents of a 1.2mb webpage into a longtext field, server has gone away

I'm taking the contents of a 1.2mb webpage into a longtext field, server has gone away though everytime! ...

MySQL field type for a comments field or text area

As the title says, I'm after a good field type for a comments field I have in a table. It will store many characters (as users can continuously add to it) so it's definitely over 255. I looked at longtext but wasn't sure...Also how do I change the field type to accept different characters such as apostrophies. Thanks. ...

Store HTML into MySQL database

I'm trying to store a String which contains HTML in a MySQL database using Longtext data type. But it always says "You have an error in your SQL syntax". I tried to store a normal String and it works. Update: This is the query: st.executeUpdate("insert into website(URL,phishing,source_code,active) values('" + URL + "','" + phishingSt...

MySql LongText unselectable with value > 32kb

I use MySql Server 5.1. I have a MySql table with a longtext column. I'm writing a program in C# 2010 using MySql Connector 6.3.1 and I want to select that column in my program using regular linq. I have inserted some text using MySql Workbench. As long as the text is <32kb, I can select it in my program. As soon as this text is > 32kb,...