How to convert Banks’ to bank's in db. all records to add Banks’ like this. how can print with Banks’ in screen.
Asked
Active
Viewed 656 times
0
Karthick Kumar
- 77
- 1
- 12
-
What's the collation on the table and the field? Looks and feels like an encoding problem. – Niklas Mar 05 '15 at 09:46
-
no no automatically add plural word. how to remove in db. – Karthick Kumar Mar 05 '15 at 09:55
-
You can use html_entity_decode to convert special characters. – rekha s Mar 05 '15 at 12:24
1 Answers
1
You can use
SELECT REPLACE('Banks’', 's’', ''\s') from table_name
Tushar
- 3,527
- 9
- 27
- 49
-
i have 1000 records how can know that particular word? example that word Banks’' ask to u. in my database bank's and college's this are convert and store Banks’',college€™' like this. how to remove all records in my database...? – Karthick Kumar Mar 05 '15 at 09:51
-
1Okay... What is the common string attached to the strings due to collation problem? is it just e€™? If 'Yes' the above query can be modified. – Tushar Mar 05 '15 at 09:53
-
1http://stackoverflow.com/questions/10177208/update-a-column-value-replacing-part-of-a-string This may be helpful for you :) – Tushar Mar 05 '15 at 09:58
-
am retrieving data in ajax this character inside db means cannot load ajax function how to solve this problem – Karthick Kumar Mar 05 '15 at 09:59
-
1
-
s i modified but not working ajax function i give like this remove all collation. bank words how to remove another words. how to stop collation adding in db? SELECT REPLACE('Banks’', 's’', '\s') from table_name – Karthick Kumar Mar 05 '15 at 10:01