i have  appearing in my db after \n. is there a a way to either run a query such as
Code: Select all
update 'content` set `TextField` = replace(`TextField` ,'Â \n','');
thanks.
Moderator: General Moderators
Code: Select all
update 'content` set `TextField` = replace(`TextField` ,'Â \n','');
Code: Select all
SHOW CREATE TABLE content;there is only one table with this problem, but there are 140,000 ish records in the table.requinix wrote:The problem is that your character encodings are wrong. Simply removing the Âs will not fix the problem.
What doesshow? And are there other tables that have the same problem?Code: Select all
SHOW CREATE TABLE content;