Tidy badly encoded DB TABLE french chars

-
These few SQL lines came in handy when wanting a quick-fix for a poorly imported table

UPDATE [rpt].[dbo].[vapProducts] SET Region = replace(Region,'Á©','é')

UPDATE [rpt].[dbo].[vapProducts] SET Region = replace(Region,'Á´','ô')

UPDATE [rpt].[dbo].[vapProducts] SET Region = replace(Region,'ÁŽ','Î')



http://stackoverflow.com/questions/5127744/how-to-convert-these-strange-characters-%C3%83-%C3%83-%C3%83%C2%AC-%C3%83%C2%B9-%C3%83


Comments

Post a Comment

Popular posts from this blog

How do you fix a roll of aluminium foil once it's started spiralling?

-
I had this problem. Seen a post on Reddit .  Old one. " This thread is archived New comments cannot be posted and votes cannot be cast" That is a shame.  As I now have a better answer than any of the posts. Get a pair of tweezers and scrape down from the part of the foil roll that is "stuck".   Don't matter if it digs down into the layer beneath.  Try to maintain even digging across the roll. Worked a treat!
Read more

Why does Premiere Pro "Sequence from clip" on MP4 and then "Match Sequence" result in a massive AVI file?

-
Image
Good Question! You would imagine that just "trimming" an MP4 file with same setting would be quick and painless, but when I tried it the resultant file was massive - like 10x the size of the original file. https://community.adobe.com/t5/premiere-pro-discussions/match-sequence-settings-mp4-to-mpeg-is-this-normal/td-p/11042944 Turns out this is because the .mp4 compression means there aren't really full frames in the file just deltas. So when you select "Match Sequence Settings", it has to give you AVI format anyway. So this is what you HAVE to do.   Go ahead and create your HUGE AVI file.  Then use an app or an online service to compress it back down... I had a good result using  https://cloudconvert.com/avi-to-mp4 It shrunk the 76Mb AVI to less than half a Mb.  
Read more

Introducing PDR: A Bold Proposal for Fairer Representation

-
I have come up with an improved method for electing MPs, and I'd like to share it with you. But before I do, let me provide some context. Currently, the UK utilises the outdated "first past the post" voting system, which needs to be reformed. In 2011, there was a referendum on adopting the Alternative Vote system, but the complexity of the proposal led to people choosing to stick with the status quo. It was a missed opportunity. Fast forward to 2019, and Boris Johnson's campaign, filled with misleading statements, resonated with certain voters, granting him a substantial 80-seat majority. Despite the majority of votes going to Remain-supporting parties, the constituency boundaries worked in favor of Boris and his team of right-wing politicians. So, what can be done to address this issue? I've explored various complex voting systems, but they tend to be convoluted and difficult to grasp. Hence, I propose a straightforward alternative: Proportional Division Represen
Read more