{"id":5742,"date":"2012-06-11T23:22:21","date_gmt":"2012-06-11T17:52:21","guid":{"rendered":"http:\/\/www.tothenew.com\/blog\/?p=5742"},"modified":"2012-06-12T11:00:59","modified_gmt":"2012-06-12T05:30:59","slug":"removingreplacing-special-character-from-db","status":"publish","type":"post","link":"https:\/\/www.tothenew.com\/blog\/removingreplacing-special-character-from-db\/","title":{"rendered":"Removing\/replacing special character from database."},"content":{"rendered":"

Recently in one of my project i faced a problem that database was having special character, which is shown as space on the User Interface.<\/p>\n

So as to solve this issue i found a very simple solution which consists of following steps:<\/p>\n

1. First, you just need to identify which type special character to be removed\/replaced like in my case it was shown as space but stored as <?> in the db.<\/p>\n

For that you can use the query.<\/p>\n

[sql]select HEX(email) from person;[\/sql]<\/p>\n

and you can also refer to this link<\/a> for ASCII code of character. In my case it was 160.<\/p>\n

2. \u00a0Now, next step is simple just run this query.<\/p>\n

[sql] update person set email=replace(email,char(160),”); [\/sql]<\/p>\n

Thats it !!! \u00a0\ud83d\ude42<\/p>\n

It helps me a lot!!! Hope that helps you guys!!!<\/p>\n

Anuj Aneja<\/p>\n

Intelligrape Software Pvt. Ltd.<\/p>\n","protected":false},"excerpt":{"rendered":"

Recently in one of my project i faced a problem that database was having special character, which is shown as space on the User Interface. So as to solve this issue i found a very simple solution which consists of following steps: 1. First, you just need to identify which type special character to be […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":7,"footnotes":""},"categories":[1],"tags":[4843,76],"class_list":["post-5742","post","type-post","status-publish","format-standard","hentry","category-technology","tag-database","tag-mysql"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t