Questions tagged [longtext]
129 questions
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…
![](../../users/profiles/4691705.webp)
Steve Ned
- 71
- 3
4
votes
1 answer
GROUP_CONCAT and Longtext
I need to combine two text fields in the MySQL Database table into One, So I have used the Following SQL script to do it.
Table: tbl_newsitems
Combine: Need to combine the text in the 'ni_text' with the same 'news_id'
Table Layout:
Code used to…
![](../../users/profiles/5161518.webp)
lbo
- 41
- 1
- 2
4
votes
1 answer
Memory consumption of having a column LONGTEXT in MySQL database
I'm creating a log table in my MySQL database. One of the field will be only used in approximately 5% of the logs and will contains stack traces and others lengthy informations for the developers. I was considering using the LONGTEXT field but I was…
![](../../users/profiles/130993.webp)
Jean-François Côté
- 3,750
- 10
- 48
- 82
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…
![](../../users/profiles/1853955.webp)
apartridge
- 1,740
- 11
- 16
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…
![](../../users/profiles/571671.webp)
a_good_swan
- 67
- 1
- 1
- 10
3
votes
0 answers
Database Query Failed on inserting huge text through textarea
I am developing an application using PHP and MySql. I have used the datatype longtext to input text data using
![](../../users/profiles/5883084.webp)
Musfar
- 39
- 1
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?
![](../../users/profiles/1794491.webp)
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…
![](../../users/profiles/176423.webp)
Walty Yeung
- 2,667
- 27
- 29
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…
![](../../users/profiles/992173.webp)
Imran Azad
- 1,354
- 1
- 19
- 35
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…
![](../../users/profiles/288564.webp)
Emmanuel
- 4,364
- 5
- 38
- 63
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…
![](../../users/profiles/9754719.webp)
bon123
- 61
- 5
2
votes
3 answers
How to apply ROW_FORMAT=DYNAMIC to an existing table
I have a table with a large number of longtext fields (18) along with a number of other various integer and varchar fields. Recently a number of additional longtext fields were added, and have suddenly forced me to learn all about 8K row size…
![](../../users/profiles/698289.webp)
DanH
- 4,628
- 2
- 43
- 68
2
votes
1 answer
MySQL: Split longtext column into multiple text columns
I have a slight challenge with data that I need to get solved. I have a table where the plain text of emails is stored in a longtext column. It was like this before I started developing in the framework. There are over a million rows already with…
![](../../users/profiles/1645497.webp)
Kobus Beets
- 29
- 4
2
votes
1 answer
Can't export SQL Server 2012 data to Excel 2007: conv. varchar to longtext (& other errors!)
I'm writing a business plan (due Monday) that depends on data in SQL Server 2012 getting exported to Excel 2007
I have a few years' experience of coding in SQL and C# but that's not my main job!
Having spend most of the day following various threads…
![](../../users/profiles/5734144.webp)
Daniel Otto Kellett
- 21
- 1
- 3
2
votes
1 answer
text enlarges the flexbox container
I don't know how to do for the text not enlarges the flex container.
If I fill one box with text when the @media is @media screen and (min-width:600px) this box is bigger than 50%. And I want to keep the same percent that when the boxes are…
![](../../users/profiles/2978441.webp)
user2978441
- 35
- 4