142 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
50
views
MariaDB: json is persisted as longtext and does not work anymore for json_value
I have following SQL (for MariaDB)
select
t.id AS id,
r.i AS i,
json_value(r.res, '$[0]') AS lat
from
tasks t
join JSON_TABLE(json_query(t.expected_answer, '$.accepted_polygons[0]'), '$...
0
votes
1
answer
55
views
How to include text for JRadioButton in the form of dt, dd inline in java swing?
I have been trying to add 2 radio buttons which indicate Modes like A and B with a long description like shown in the below image.
I need,
the Mode names to appear in bold text
the following sentence ...
0
votes
0
answers
47
views
Converting MySQL MyISAM longtext to Innodb
I am belatedly converting some php applications using MySQL from MyISAM to Innodb. One set of tables were converted on Friday, and now on Monday there are problems. Specifically for one table used ...
0
votes
1
answer
503
views
How do I update a long text field in from a long text field in another table without truncating
How do I update a long text field in from a long text field in another table without truncating fields that exceed 256 characters?
I have two tables.
tbl_current_text with two fields: system_id, ...
0
votes
0
answers
135
views
How to get data from a LONGTEXT to perform string operations
I have some MariaDB code, which I'm fairly new to. I'm a seasoned MSSQL developer, however. I have a script with a variable which I'm setting to what will eventually be the contents of a file. This it ...
0
votes
1
answer
246
views
KivyMD - Button wrap text
Somehow I can't find out if it is possible to make long text in a button wrap in KivyMD.
In classic Kivy, this is done with "text_size: self.width, None"
But in KivyMD no matter what I do ...
0
votes
1
answer
183
views
writeTextElement() of QXmlStreamWriter crashed when writting the content of a big file
Here is the qt code that crash:
Writing the content of a 130MB binary file will crash, but writing a 2MB binary file will not.
Is there any solution for writeTextElement to write big file content? ...
0
votes
0
answers
171
views
How to insert a long text in a multirow on overleaf?
Helle,
I would like to create a table wit my 2 first row being multirows with one filled with a long text, followed by a 2 column's row.
I don't have any issue to create the multirows or insert the ...
0
votes
1
answer
964
views
Changing column from longtext to mediumtext taking over 1 hour
I am storing html in my database as text, and initially I used longtext because I just assumed it was what I needed. I queried my html and urls from my database using the full text and it took a long ...
2
votes
2
answers
52
views
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 = ...
0
votes
1
answer
127
views
MariaDB Remove text from record
I have longtext data in data column as show by image, how to remove
{"current_id_position":"8861","targetted_id_position":"","count_new_technical":&...
1
vote
1
answer
272
views
Error inserting in Microsoft Access 2002-2003 "long Text" field SQL Server 2019 linked Server Microsoft Access Database Engine 2010 x64
I am attempting to migrate a number of stored procedures, which insert to Microsoft Access 2002-2003 format database files, as linked servers.
The process is currently working fine on the following ...
1
vote
0
answers
360
views
Flutter flip card package with long text
I used flip_card package(https://pub.dev/packages/flip_card/example) inside ListView.builder. And it seems to work very well. But after I just touched the card several times(more than 10 times) to ...
0
votes
1
answer
691
views
Longtext data to PHP Array
I inserted the array data in MySql table by encoding to JSON using json_encode($arrayData), but in longtext data type, not in JSON data type.
So I am not able to do json_decode($...
0
votes
0
answers
866
views
MySql/MariaDB longtext truncated and max_allowed_packet
I have a problem with MariaDB with a longtext field. It is limited to 32770 chars and there is no way to grow it up.
SELECT CHAR_LENGTH(longtext_column) from table where id = x;
I edited my cnf like ...