Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Data Bridge General / Announcements › Need to change some entries in column to NULL

Need to change some entries in column to NULL

Thread began 8/07/2017 6:19 pm by EmmaMorris | Last modified 8/08/2017 9:21 pm by EmmaMorris | 2562 views | 10 replies

8/08/2017 8:02 amEmmaMorris

Ok.. My bad.. Got that to work. I was running the 'simulate query' when it gave the error.. Actually running it succeeded.

Got rid of the   .. Found another character I need to get rid of. It is the Â character. Doing some searching it seems to have something to do with the collation. It is set as latin1_swedish_ci . Should I change that to a different collation and will that mess up the db by doing so.

If I do the same UPDATE with that character (Â) it does not find it so I cant get rid of it.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.