Stack Overflow
Stack Overflow

Questions tagged [longtext]

143 questions
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…
Kobus Beets
  • 29
  • 5
2
votes
1 answer

Best practice for working with long texts in ms-access

I would be very thankful if somebody resolves my problem. I'm new in working with Ms Access and I still gain experience on its basic functionality. I have a table MyItems. 2 of its fields are: ItemCode and ItemName. ItemName is a very long text…
Peter
  • 23
  • 6
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…
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…
user2978441
  • 35
  • 6
2
votes
2 answers

Laravel Eloquent object, longtext being truncated

I've using Laravel, loading a db row into an Eloquent object. One of the columns is longtext, a JSON encoded array > 2 million characters long. The original error I was getting was json_decode failing on this column's value. I tested in tinker.…
wakeman
  • 343
  • 3
  • 13
2
votes
0 answers

Truncated Text on Select Menu for Android Phones

screenshot of problem I am currently testing a website I am working on on Android devices. I noticed that the text is getting cut off for the longer options on the select menu aka drop down menu. I know that the text is lengthy but I would like…
hglen7312
  • 21
  • 2
2
votes
1 answer

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…
Yvonne
  • 155
  • 7
  • 14
2
votes
2 answers

Pulling data from SAP using Excel Macros

So I am trying to pull data from SAP GUI using Excel macros. I am new to VBA so please bear with me. I found a topic on here called VBA pulling data from SAP GUI for dummies and I am confused. What I am trying to do is as follows: Copy a…
adastra
  • 47
  • 1
  • 1
  • 9
2
votes
4 answers

A long text in the TextView

I have a button, and when i click to it, i make textView.setText() a very big text, 50000 symbols, and the interface stops for 3 seconds, how can i fix it? I tried to make it with Handle and thread, but it hasn`t helped. I tried to make…
user2096488
2
votes
1 answer

MySQL LONGTEXT pagination

I have table posts which contains LONGTEXT. My issue is that I want to retrieve parts of a specific post (basically paging) I use the following query: SELECT SUBSTRING(post_content,1000,1000) FROM posts WHERE id=x This is somehow good, but the…
user1690753
  • 21
  • 1
2
votes
1 answer

MySQL Comparative querying longtext columns

I have a LONGTEXT column that I use to store paragraphs of text. Let's say that within these paragraphs there is something like: Text text text text COUNT: 75 text text text text text text text text text text Would it be possible to do a…
Norse
  • 5,674
  • 16
  • 50
  • 86
1
vote
1 answer

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 configuration Windows Server 2008 R2 Standard SQL…
Matt
  • 23
  • 4
1
vote
0 answers

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 test flip effect, it became extremely slow and my…
wfg1205
  • 13
  • 4
1
vote
0 answers

Extract data from field json (longtext) in mariadb

I have a field longtext with data JSON: How can I extract the data from this field?
Rodrigo Marozzi
  • 11
  • 1
1
vote
1 answer

Can MySQL satisfy a query from a prefix index?

I wonder if a covering index can help, for some rows, satisfy a query from a LONGTEXT or any other LOB column? (MySQL 8, MariaDB 10.5) I have this table (WordPress-defined): CREATE TABLE wp_options ( option_id BIGINT UNSIGNED NOT NULL…
O. Jones
  • 103,626
  • 17
  • 118
  • 172
1 2
3
…
9 10