locked
how to replace a pilcrow symbol (¶) in MYSQL? RRS feed

  • Question

  • User944339287 posted

    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>') 




    Wednesday, October 23, 2019 4:19 AM

All replies

  • User753101303 posted

    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...

    Wednesday, October 23, 2019 12:45 PM