Stack Overflow
Stack Overflow

Questions tagged [longtext]

143 questions
0
votes
1 answer

Do char / varchar / text / longtext columns in MySQL occupy full size in filesystem even for partially filled cells?

Do varchar/text/longtext columns in MySQL occupy full length size in filesystem even for incomplete cells? Referring to this blog article for example I have the following columns and i have put in a given string in it. CHAR (72) - can store upto 72…
Rakib
  • 12,376
  • 16
  • 77
  • 113
0
votes
1 answer

PHP - Storing paragraph in MySQL Table

I might sound silly with simple questions . i am newbie exploring PHP , kindly help me mates. I want to store paragraph in MySQL table . My PHP code was $text="This was the first book or more to say a novel, I read in my life. when I read other…
Raja Gopal
  • 1,845
  • 1
  • 17
  • 34
0
votes
2 answers

swift long non editable text in textview (i can't see text from the beginning)

I'm trying to insert a long non editable text using TextView in Swift. No problem with length or vertical scrolling. The problem is that when UIView starts I can't see text from the beginning but I always see the final part. I attached 2 images:…
Stefano Ramilli
  • 71
  • 1
  • 6
0
votes
1 answer

Why won't ADODB open an Access table containing a long text field in rich text format?

This seems so dumb. I have a table with a long text (aka Memo) field, and the text format is set to Rich Text. Of course I can open the table directly or through an Access form. What I cannot do is open the table in an ADODB recordset. Or I should…
Scott Pendleton
  • 1,021
  • 3
  • 16
  • 32
0
votes
1 answer

Is that a good practice to put several longtext into a same table mysql?

I am creating a mysql table which contain several longtext rows. I am expecting a lot of users enter a lot of texts. Should I split them into different table individually or just put them together in one table? I concern about the speed, will that…
conan
  • 1,327
  • 1
  • 12
  • 27
0
votes
1 answer

MySQL query to select SUM of longtext data type and store result as variable

I need to select some values from a table column which has a datatype of "longtext" where another column has a specific value and add those values up. I need to store the sum as a variable which I will a.) echo on a webpage, and b.) use the value…
Jason
  • 871
  • 1
  • 8
  • 18
0
votes
1 answer

Web application running on both Oracle and MySQL

I have a web application that works on both Oracle and MySQL Databases, my problem is that I want to create a column in the database that has a LONGTEXT type in MySQL and CLOB in Oracle, how can I achieve that using Hibernate? Here is my…
Shahe
  • 964
  • 2
  • 13
  • 34
0
votes
0 answers

Lucene 4.7 long text index

i'm trying to index some long texts with Lucene 4.7, i thought that all was fine but i realise that my search hits are not complete. After a long search i found a web page that said something like "When I try to index a long text in Lucene, Lucene…
Paco
  • 1
0
votes
0 answers

Search LONGTEXT and display a specific line from that text

Okay, So short and sweet. I have a field in my database that is LONGTEXT. This field usually has around 2,000 lines of text in each of these. What I need it to do, is go through this LONGTEXT field and take out the line that has what is inputted to…
ThePsychoMonkey
  • 1
  • 2
0
votes
1 answer

How can I add long text in ContentPlaceHolder?

I'm working with Asp.net. My problem is adding long text inside ContentPlaceHolder. I want to create scrollbar. Which way should I use?
AyseUnal
  • 3
  • 2
0
votes
1 answer

How to read a particular tag data from longtext type in mysql?

I am new to database so please advise me how to read data from a longtext(clob data type) in my sql. The longtext field name is Rest_Server and the value tag to be read is from that.
Learner
  • 1,544
  • 8
  • 29
  • 55
0
votes
1 answer

query very slow longtext field innodb table

Well, firts of all, sorry by my english. I try to do a query in a table that the users can include some text, like a blog page. The users can design the content in a html format. In my table it is stored like this: Estad&iacute;sticas<br…
Anibal Mauricio
  • 517
  • 2
  • 5
  • 17
0
votes
0 answers

How to insert long text in Mysql database ("Text" Datatype) using PHP

I am trying to insert long text into a mysql database using PHP. I am using data type "Text" for storing long text, but the problem is that "Text" data type is not storing the value, but if I use "Blob" instead of "Text", it works. One thing I…
Saadi
  • 21
  • 1
  • 6
0
votes
2 answers

generating tables from jpa with limited character length

I want to create a text field in a database with varchar(700) (I want 700 characters max). I tried to define it like this: @Entity @Table(name = "t_foo) public class Foo { @Column(unique = true, nullable = false) @Id private String…
beanf
  • 37
  • 1
  • 7
0
votes
2 answers

php/mysql - only a fragment of a long text is inserted into DB

In my code, I use the variable $content. It's a text string with a length of ~200000. $session doesn't matter in this case. If i try to insert the following data, ... $c = mysql_real_escape_string($content); mysql_query(" INSERT INTO data (time,…
Fidelis
  • 339
  • 1
  • 4
  • 11
1 2 3
…
9
10