How can I store a very big text in sql?

Question

Am currently working on a project that requires a very big text input. It's a lengthy string.

Answer 1

Put the text into a cloud and store the link in sql.

Answer 2

@ipang parallel to u😃

Answer 3

De-Virus

You can't store more than defined size so you need to put size as max.

If you defined size as 100 but you are sending content more than that then you will get error. I am sure this is happening in your case.

We can store more than 1000 characters. It is just a example. There maybe more than 1000.

If your content is too much then better to store in a file.

Answer 4

How big is this text you're working on anyways?

If it was troubling you a lot, maybe you can opt to upload the file and save it in a directory as a file.

Answer 5

De-Virus external storage is a good option. Also look into whether your DB engine supports a Memo field type like SQL Server does, or maybe BLOBs -- Binary Large OBjects.

Answer 6

See the data type table below, and pick one that suits your necessity.

https://www.w3schools.com/sql/sql_datatypes.asp

Answer 7

Thanks but still am facing the same problem.

Answer 8

It's a website and when I try insert a big text in the database it fails. It only works when I reduce the text length.

Answer 9

Frogged
Good and modern idea 👍

Answer 10

Thanks a lot for your time and help.

Answer 11

you can simply put the text into a cloud and store the link in sql

Answer 12

simply extend time in php.ini
execution time..extentend..
and phpmyadmin me default file me extend karni hoti h