error are not coming when add single word data in columns don,t matter hindi or engllish work fine.
but when i add multiple line and multiple words text in columns then i got index issue.i find the exast problem now.
see app is working correctly but if add more then one word in mysql column then i got list index issues.but full data is comming if i store 10 words in tittle column then 10 words are get while fetching data i text this with label but when i store this value to list then i got index issue!so problem in indexing or adding value to list from comming data
Friend, why store 10 words in a field? Field is a column where we store the same type of information. So if you want to store 10 titles you will have to create 10 records that represent 10 rows in the database table.
Ok then use Bloob data type instead of text data type
Your problem will get fixed
I aslo have faced this issue once Changing to bloob is the perfect solution
But the bloob? Varchar accepts. But I don’t think I understand what he’s trying to do. I understand that he is confusing columns with lists.
10 títles in one column ? Issues Index ?
Don’t you think so too?
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
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
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… )
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.
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
