Stack Overflow
Stack Overflow

Questions tagged [longtext]

143 questions
1
vote
1 answer

How can I ignore bulk load data conversion error (truncation)

I have a file that is an extract from a MySQL table that I would like to in turn load to a SQL table (csv file) through a SSMS job. However, there is a field in the file that is defined as "LONGTEXT", which is way too long for a SQL table. I'd…
Henry
  • 17
  • 4
1
vote
0 answers

Data is being truncated while storing in database even in LongText data type

I have encountered a strange problem. I try to save a large content on db where my field is set as longtext . When I post the data and dump it, complete data is being posted. but when I try to upload it to the database, the data is being…
Meeraj Adhikari
  • 362
  • 5
  • 15
1
vote
1 answer

How to remove long text format "@" (MS Access)

I'm working with access office 365 MSO. While importing excel files into access, sometimes long text columns will be assigned with the format "@". This somehow can lead to truncate the content. Currently I manually have to remove this "@" symbol,…
PiusL
  • 13
  • 2
1
vote
0 answers

after push data to mysql, the columns type (in DB) become default

I created mysql DB, then i changed some variables types to "longtext", then i created dataframe in pandas, and pushed that df to DB df.to_sql("my_table_name", conn, index=False, if_exists = 'replace') this command insert data to DB but the…
Amir saleem
  • 1,404
  • 1
  • 8
  • 11
1
vote
1 answer

mySql SELECT GROUP_CONCAT query not return all data in longtext cell

I have a cell that contains a very long string. If I use this query: SELECT dettPDE FROM bollaOutDett WHERE idDoc>0 GROUP BY idDoc; I have no problem, but in some cases I need to use this: SELECT GROUP_CONCAT(DISTINCT IF(dettPDE='',NULL, dettPDE)…
Francesco G.
  • 679
  • 3
  • 13
  • 32
1
vote
0 answers

Why Laravel is truncating large text in the db

My table field is Longtext, however when I try to save a text of length equal to 3 page of a text book. It saves in the db but not complete. It truncates the text. What is wrong, do Laravel set default max length of a payload? Is it a problem…
user9446265
1
vote
2 answers

MySQL Long Text Field Export to CSV Excel

I'm trying to get data out of MySQL table and into a csv so I can edit in Excel. There is a note field that is extremely long and has a ton of different characters. When I open the file in excel it throws the data all out of place. Any ideas on…
user3058374
  • 11
  • 3
1
vote
1 answer

Text Greater Than ~43,700 Characters Disappears In Datagridview Vb.net

I have a DataGridView that displays database entries. The problem is that many of my strings that are very long do not show up in the cells. The data is there because I can select the cell, copy the contents and then paste them into a text file…
Jamie
  • 555
  • 3
  • 14
1
vote
0 answers

ERROR 1064 (42000): You have an error in your SQL - When trying to insert a response json into my mysql

Im trying to insert a response object into MySQL Database, but it fails every time. INSERT INTO response(`debug_response`) VALUES (' { "STATUS": {"code": 200}, "REQUEST": {"q": "The ABC Murders", "resource":…
Archie
  • 83
  • 10
1
vote
1 answer

What is the proper way to break a long line of code in CSS onto another line?

I have searched a lot on google and can't seem to find what to do with a line of CSS that is really long. If I want to split that code and finish it in another line, how do I go about doing this? Should I do it? for example: src:…
Garrett F
  • 21
  • 2
1
vote
2 answers

Python mysql update with no subquery results in subquery error

I have the following code conn = MySQLdb.connect(server, user, password, database, autocommit=True, charset='utf8') for e in list_to_updpate: nid = e[0] vid = e[1] text = e[2] delta = e[3] deleted = e[4] …
Todor Kostov
  • 107
  • 1
  • 1
  • 10
1
vote
1 answer

Hibernate: Additional annotation to Column from inheritance

I have a class @MappedSuperclass public abstract class MyAbstractProperty { @Id @GeneratedValue(strategy = GenerationType.TABLE) private Long id; @Column(name="defaultValue") protected T…
BerndGit
  • 1,530
  • 3
  • 18
  • 47
1
vote
1 answer

Android TextView with ellipsize attribute moved from the original position

I have found a strange behavior with the Android TextView and the ellipsize attribute. When the text is long and the ellipsize attribute is applied, the original position of the text is lost and the text appears a bit upper. Yes, I can solve it…
aLx
  • 121
  • 1
  • 6
1
vote
1 answer

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…
JeroenNL
  • 203
  • 2
  • 9
1
vote
0 answers

Inserting long text into nVarChar(max) column in SQL Server 2014 using C#

I am trying to update a column in a SQL Server DB from C# that is defined as nVarChar(max). The update works as long as the text length is 4000 characters or less. As soon as the length is 4001 I get the infamous error: String or binary data would…
Shanew44
  • 19
  • 1
  • 3
1 2 3
…
9 10