Last post Oct 23, 2019 12:45 PM by PatriceSc
Member
103 Points
796 Posts
Oct 23, 2019 04:19 AM|kengkit|LINK
Hi,
I have tried the following but failed. Any idea?
UPDATE table1 SET myfield = REPLACE(myfield, CHAR(182), '<br><br>')
UPDATE table1 SET myfield = REPLACE(myfield, '¶', '<br><br>')
All-Star
48720 Points
18184 Posts
Oct 23, 2019 12:45 PM|PatriceSc|LINK
If it doesn't change anything it is perhaps not the character code you think ? Not familiar with MySQL but my first move would be to use ASCII (or maybe ORD) to make 100% sure about which character it is...
Member
103 Points
796 Posts
how to replace a pilcrow symbol (¶) in MYSQL?
Oct 23, 2019 04:19 AM|kengkit|LINK
Hi,
I have tried the following but failed. Any idea?
All-Star
48720 Points
18184 Posts
Re: how to replace a pilcrow symbol (¶) in MYSQL?
Oct 23, 2019 12:45 PM|PatriceSc|LINK
Hi,
If it doesn't change anything it is perhaps not the character code you think ? Not familiar with MySQL but my first move would be to use ASCII (or maybe ORD) to make 100% sure about which character it is...