Skip to main content

Posts

Showing posts from October, 2015

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


Home Truths

Had to pinch a couple of thesehttps://www.facebook.com/MicrosoftDeveloper/photos/a.237767339690433.61184.231824870284680/533208980146266/?type=3&theaterhttp://www.wickedfire.com/shooting-the-shit/175475-anyone-else-hate-not-being-programmer.htmlAnd one I could not find….   There is a graph showing how much as a percentage a programmer thinks a project is completed, vs how much its actually completed.If someone knows where I can find this graph  - please let me know.    Here is the rough idea: