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

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

Landcycle: Unveiling My Property Development Toolkit

-
Image
Greetings property development enthusiasts! I'm thrilled to share a project that's close to my heart – Landcycle. It's been 3 years in the making: Blood, sweat and tears have all featured in it's production. As the primary developer and project manager behind this venture, let me walk you through the features that make it a game-changer in the realm of England and Wales property and land projects. Map-based plot exploration: Landcycle starts with a simple yet powerful interface that lets you visually explore land plots based on Land Registry titles. Imagine an interactive map offering insights into potential development sites and ownership details – all within a few clicks. Constraint layers at your fingertips: Understanding the specifics and constraints of a potential development site is paramount. Landcycle simplifies this by layering on information like flood plains, green belts, railways, roads, and more. It can be an amazing too for assessing a plot's viabilit...
Read more

Drop off and pick up at Gatwick Airport

-
Image
I've become a bit of an expert at drop off and pick up at Gatwick Airport over the last couple of years. Gatwick Airport have committed to 52% of journey to and from the airport being made by public transport by 2030.  Very commendable. Seems they intend to do this by raising parking charges to levels that include the loss of arms, legs and even testicles. " The charge will be £5 for 10 minutes, and £1 for each additional minute up to 20 minutes. The maximum charge will be £25 and the maximum length of stay 30 mins." Today it is £6, for both quick drop-off and up to 15 minutes pick-up. It says there "£25" maximum charge.  I don't believe that. What to do We had a double-pickup yesterday - friends leaving, being dropped-off at 13.50 and daughter arriving back by 16.30.  When I entered this into the pre-booking system it says £55!  There are only 30 minute increments available. So what I did this time was drop the friends of, and drop off wife...  £6 for the...
Read more