Last post Oct 23, 2019 12:45 PM by PatriceSc
Oct 23, 2019 04:19 AM|kengkit|LINK
I have tried the following but failed. Any idea?
SET myfield = REPLACE(myfield, CHAR(182), '<br><br>')
SET myfield = REPLACE(myfield, '¶', '<br><br>')
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...