Stack Overflow
Stack Overflow

Questions tagged [longtext]

143 questions
4
votes
4 answers

Unable to save large text in mysql thru php

$query="INSERT INTO `ARTICLES` (`TITLE`, `BY`, `IN`, `POST`) VALUES('". $title ."', '". $by ."', '". $in ."', '". $_POST['post'] ."')"; This code is able to save small length text but not large. The datatype for the POST field is longtext. Also if…
draxxxeus
  • 1,503
  • 1
  • 11
  • 14
4
votes
3 answers

Trouble with GROUP_CONCAT and Longtext in MySQL

The SQL... UPDATE Threads t SET t.Content = ( SELECT GROUP_CONCAT(a.Content ORDER BY a.PageID SEPARATOR '') FROM MSarticlepages a WHERE a.ArticleID = t.MSthreadID GROUP BY a.ArticleID ) As you can see it takes all of…
Iwasakabukiman
  • 1,453
  • 4
  • 15
  • 17
4
votes
1 answer

golang reading long text from stdin

I want to read a long text from os.Stdin, but I can't make it happen. Already read everything in the subject, tried codes that supposed to work. Every method cuts after 4096 characters, no matter what. Eg. here's a working example. After the first…
vendelin
  • 138
  • 1
  • 3
  • 16
4
votes
0 answers

'Impossible WHERE noticed...' with MySQL INNER JOIN on LONGTEXT cols. Options?

I am investigating a slow running SQL query on a production mySQL database, and looking for options on improving performance. I did not design or implement this, but I do need to fix it. The intended purpose of the SQL is to check if the same…
Steve Ned
  • 81
  • 3
4
votes
1 answer

How are longtext columns stored on the disk?

I'm working on an email support system. Each stored email contains from_email, subject, date, some flags, and the contents of the mail. Clearly, the amount of mail can be large, and our system is mainly focused on the most recent messages (for…
apartridge
  • 1,790
  • 11
  • 18
3
votes
0 answers

Altair tooltips: Is there a way to format box shape for long text?

I have a chart where I want to display text tooltips of variable lengths as long as 300 characters, but they are displayed with random box sizes. Sometimes they are shown in a neat square box with several lines of text, which is nice. But sometimes…
flbyrne
  • 181
  • 1
  • 9
3
votes
4 answers

Removing newlines in PHP - but they still show in LONGTEXT in MySQL

Ello chaps. Ok - cleaning my string like this: $clean_string = preg_replace("/[\n\r]/"," ",trim($dirty_string)); .. Echo it out to the screen and it works - one lovely big lump of text with no newlines. INSERT it into a LONGTEXT type field in MySQL…
a_good_swan
  • 65
  • 1
  • 1
  • 10
3
votes
1 answer

will mysql compress text field reduce disk space on current database?

I have a rather large mysql database table where one field is longtext, I wish to use compress on this field, would this result in diskspace reduction? or is the storage space already allocated and it won't result in any space reduction. the…
user121196
  • 30,032
  • 57
  • 148
  • 198
3
votes
2 answers

VARCHAR versus TEXT or LONGTEXT

If a blog post is 200 characters long, will varchar(6500) only consume the space of varchar(200)? Will this be more efficient than using TEXT or LONGTEXT?
user1794491
  • 31
  • 1
  • 1
  • 2
3
votes
4 answers

mysql innodb inner join with longtext very slow

I migrated all MySQL tables of one project from MyISAM to InnoDB last week, in order to support transaction. I used the command of alter table for this. Most works fine, however one particular query runs very very slow, and it always gives the…
Walty Yeung
  • 3,396
  • 32
  • 33
2
votes
2 answers

saving base64 data - row size too large issue

I have 22 database fields of type longtext. If I try saving 12 of the fields with the following data I get the following error: #1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. You have to…
Imran Azad
  • 1,384
  • 1
  • 21
  • 36
2
votes
2 answers

for loop using ggplot for longitudinal data

I am trying to visualize my longtudinal data by graphs using ggplot through for loop. for(i in colnames(dat_longC)[c(3,5:10,14,17:19,30:39)]){ print(ggplot(dat_longC, aes(x = exam, y = i, group = zz_nr))+ geom_point()+ geom_line() +…
Nuhash
  • 21
  • 1
2
votes
1 answer

Why does mysqli fetch() return empty results from longtext column?

For some reason mysqli $query -> fetch(); returns blank, the columns that are longtext in my mysql table? Any ideas? I set the columns to text, it works fine. It also works fine on my WAMP server, but when I put it up to the production server it…
Emmanuel
  • 4,933
  • 5
  • 46
  • 71
2
votes
0 answers

EditText ellipsize (three dot)

I want to customize android edit text so that when clicked outside, it will automatically scroll back to first and show three dots at the end if the text is too long. I have customized it to try it to run well but not yet optimized, please refer to…
Đức Dương Văn
  • 21
  • 1
2
votes
2 answers

SQL max size LONGTEXT

I created this table: CREATE TABLE Hospital_MedicalRecord( recNo CHAR(5), patient CHAR(9), doctor CHAR(9), enteredOn DATETIME NOT NULL, diagnosis LONGTEXT NOT NULL, treatment TEXT(1000), PRIMARY KEY (recNo, patient), CONSTRAINT…
bon123
  • 61
  • 1
  • 6
1
2
3
…
9 10