Field type bloob…
But does he really want a 10-line in title? My God, we’ve been talking about UTF-8 for hours … and it wasn’t like that … 
1 Like
No no his problem is whenever he tries to save a text of length of more than one words he is unable to get them in his specific index instead the retured text get mixed or something like this
But when he tries to save only one word it works
Actually this problem is very odd but i also have faced this one and it can only be solved by two methods
method 1
Use text encoding and decoding
(m using thiz and it works fine and text encryption is also recommended if u want to save your data)
Method 2
Use Blood data type it aslo has the ability to solve the issue
Because of the language with special characters? I never saw that …
“Gone with the Wind”
That is same words ?
1 Like
No no it is not related to special characters its related to spaces between text
If text is long and contains a larger number of spaces then it happens
And it also related to pho my admin
Because in some hostings i saw it is not an issue but in some it happens i
And ts very odd behavior
I don’t know hindi so can’t say anything!!
Okay … it hasn’t happened to me yet … really weird …
1 Like
Let’s seee… Btw its interesting… And topics like thses let us learn a lot of new and amazing things
1 Like
Free hosts?
No m using a paid one it shows thia error
But i think 000webhost that’s free but it doesn’t show this error ( i didn’t remember exactly but probably it worked fine… )
See here in this thread i asked at that time about the vary same issue
1 Like
I’m researching … I haven’t found anything yet … in Google
“text is long and contains a larger number of spaces”
But … finally, the solutions you have already shown what they are. 
1 Like
Ohhhhh ! 
This is a poem, a book with chr(13)… within a varchar field it will give problems.
Blob Field Solution !
1 Like
No its not varchar
Its text filed
Is not it!??!! 
We used to say them “jugards” (in punjabi language ) 
But i guarantee they work
I already answered above that you already gave as solutions. 
I didn’t understand the emoticon.
1 Like
Yes i know s!r… I just write it again because i was providing full set of my solutions…
And the emotion is because i think as you are saying that its a wrong solution so i add that emotion instead of question mark
I really like this emoticon because its eyes and way of seeing is cool
1 Like
if your data contains more than one line try this
1 Like
@Rogerio_Rios see in this thread now its confirm that its happening because of spaces as i mentioned above
Its idea is unique too as if some insisted to store in text filed then its a best way
A new trick to learn 
After searching that the languages with special characters allow the field capacity.
1 Like
Yeah u r right
Btw its always gets some kinda hot discussion on databases with you
1 Like