Stack Overflow
Stack Overflow

Questions tagged [longtext]

143 questions
1
vote
1 answer

store text of character length ~300,000 in mysql database

I have a column of data I would like to add to a mysql database table. The column is raw text and the longest piece of text contains approximately 300,000 characters. Is it possible to store this in the table? How? I have been reading that even…
JoeDanger
  • 3,325
  • 4
  • 13
  • 14
1
vote
4 answers

Store HTML into MySQL database

I'm trying to store a String which contains HTML in a MySQL database using Longtext data type. But it always says "You have an error in your SQL syntax". I tried to store a normal String and it works. Update: This is the…
jouzef19
  • 63
  • 4
  • 11
1
vote
2 answers

how to store big text data in two tables with an id link using mysql and php

i have a database with table in which one column is 'project_stmt' which store text data. I have set data type to varchar(1000) but sometimes use input text of project statement is exceed very big like 100K chars, in that case data is not stored to…
rajnish
  • 25
  • 4
1
vote
1 answer

pdo/json longtext sometimes return as null

I've a table with content pulled from a pdf file page wise (separate row for each page). It works fine but some of my results are returned as null even though the content exists in the table row? Why some are returning as null? $q =…
user2727195
  • 7,122
  • 17
  • 70
  • 118
1
vote
1 answer

what is the best way to display long text in xaml for windows phone app

In my project .I need to display loog texts,it is some kind of book app project .i know how to read a txt file in c# but it doesn't look efficient to me there should be more easy and customable ways. do you know any other way to display long texts
cihad yildiz
  • 43
  • 7
1
vote
2 answers

android viewpager to contain a long text separated to pages

I have a viewPager in my app. I want to put a long block of text in the viewPager. I don't want the text to be scrollable, I want it to be separated or parted to pages, and when the user pages it shows the rest of text in the other pages. How can I…
user3218456
  • 23
  • 5
1
vote
0 answers

HTML tags from database showing in fixed div

I have a div where i display formatted text from database and there is also pagination when the number of characters that i want to display in the div are used up. However, there are times that the html tags are being displayed also. I think i must…
Nhiz
  • 120
  • 3
  • 14
1
vote
0 answers

Wordpress database error- #1071 - Specified key was too long; max key length is 1000 bytes

I have a WordPress blog but it has some strange characters in the content like �. I found in my phpmyadmin, that in my wp_posts table, the column post_content is using latin1_swedish_ci collation. I am trying to change it to utf8_unicode_ci but it's…
Kunal Sharma
  • 11
  • 2
1
vote
1 answer

How to cast a Javascript String to SQL LongText

I am facing a problem for an hour or so with a LongText column in SQL. I am currently working on a web project where at some point we have a search form which allows user to search through numerous fields. Due to the customer's users being forced to…
Michael De Keyser
  • 787
  • 1
  • 17
  • 45
1
vote
10 answers

storing long text

what is the best way to store long texts (articles) in a database? it doesnt need to be searchable. i want to allow ppl to read the first chapter of every book in my bookstore. dumping it into a database field makes it difficult to style paragraphs…
Noam Smadja
  • 915
  • 2
  • 8
  • 29
1
vote
1 answer

Longtext in Mysql not working in live server...Showing Forbidden Error

in my project I have one text field for project details(longtext). In localhost it is working fine, but in live server when I am trying to add the details, it is showing Forbidden error. I tried with small one or two lines of description, it is…
Saswata Sundar
  • 586
  • 1
  • 4
  • 15
1
vote
1 answer

issue with Storing and Editing very very long text my php MySQL

I need to store and update a very large text into MySQL database. I took the input via form textarea. but the MySQL query seems to fail to execute if the text is too large. Is there any efficient way to store long texts via PHP-MySQL? I am using…
Hossain Ahmed Saiman
  • 69
  • 3
  • 14
1
vote
3 answers

iphone Custom table cell, UILabel needs to be scrollable

I have a custom table cell with a UILabel in. What I want can be done with two ways. 1- Find the height of the Label that contains long text and set the rowHeight to make the whole text visible. 2- Make the UILabel scrollable so the user can move…
Panos
  • 7,227
  • 13
  • 60
  • 95
0
votes
1 answer

Creating a counter for occurrences of lottery numbers in MYSQL longtext column. This may require PHP

I may need PHP or some other language to do this job, though A solution in MYSQL directly is preferred. I've gotten together a list of the winning lottery numbers for the New York state lottery for the last year. I've created a 4 column table in…
user1036695
  • 1
  • 1
0
votes
2 answers

In Android how can I show a very long text (190 words), is there any idea better then textview?

I have a long text, about almost 1000 character including spaces (190 words). I tried to show that on a large textview, but it wasn't that great, didn't look pro, so is there any other idea? Thanks for helping, and for trying to help.
Great Dreams
  • 91
  • 3
  • 13
1 2 3
…
9 10