How-to – Page 11 – My Brain BLOG

How to Fix the Collation and Character Set of a MySQL Database

Sources: mostly here and not so much here.

Something about MySQL being swedish and having a default character set of latin1 and a collation of latin1_swedish_ci which is no good if you need to save utf8 data.

Remove an App from the App-stores

It’s a sad time; end-of-life for your cherished App, where you have to stop users from being able to find your App in the AppStores from Google Play and Apple App Store.

Unfortunately; you have to struggle and find the option where you can actually remove your binary and your Store Listings.
Here is how to do it:

Wind and Solar Power Grid Connection

Free energy is a nice idea; unfortunately you need to invest in some equipment to actually make it happen. Trying to build the following setup, thank you aliexpress:

The components are: windmill, wind charge controller, tiny solar panel, solar panel charge controller, a 12v battery, some 12v DC cables and wires and a couple of switches to tie it all together.
Still working on the choices for the grid tie converter.

* ^{advertisement:}

^{get a free coupon for new users here}

That’s all folks!

Send To Outlook

Client with a question:

Windows file explorer,
on document do a right-click,
select Send to – Mail recipient

…. and this opens Windows Live Mail instead of the default Outlook.
You would suspect Windows-Settings-Apps-Default Apps to be set incorrectly, but this was not the case.

IDE1006 Naming rule violation

Thank you visual studio with your strange default settings, causing the error/warning all throughout my code: “IDE1006 Naming rule violation: These words must begin with upper case characters”.

Go Google, find this, and solve it actually like so:

By going to Tools > Options… > Text Editor > Basic > Code Style > Naming
Click ‘Manage Naming Styles’, add new style ‘camelCase’ (or whatever else you require), and save.
Set the Required Styles to camelCase and save by clicking OK
Thank You Microsoft!

Have a nice day!

Icepay cURL 60 SSL problem

To be precise, the error is: “Unable to reach the ICEPAY payment server (60):SSL certificate problem: unable to get local issuer certificate“

The solution could be:

curl_setopt($this->ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($this->ch, CURLOPT_SSL_VERIFYPEER, 0);

or, which also works in my case:

curl_setopt($this->ch, CURLOPT_SSL_VERIFYHOST, 2);
curl_setopt($this->ch, CURLOPT_SSL_VERIFYPEER, false);

Of course bypassing SSL security is never the correct option, but for a development server we all make exceptions sometimes.
Have a nice day!