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 removed/replaced like in my case it was shown as space but stored as <?> in the db.
For that you can use the query.
[sql]select HEX(email) from person;[/sql]
and you can also refer to this link for ASCII code of character. In my case it was 160.
2. Now, next step is simple just run this query.
[sql] update person set email=replace(email,char(160),”); [/sql]
Thats it !!! 🙂
It helps me a lot!!! Hope that helps you guys!!!
Intelligrape Software Pvt. Ltd.