I was trying to restore a database to a MySQL server on a test machine and this error occurred: #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’ The problem is, the server that runs the live database is MySQL 5.7 that supports utf8mb4_unicode_520_ci but the test server I run is only MySQL 5.5 which does not support this specific encoding. By the way, […]
Database Note Taker is a free note-taking app made specifically for SQL databases. It makes a database schema and structures a lot easier to capture and document, and definitely simplifies the database documentation and takes the guesswork out of everyday development with databases. How does it work? More specifically, Connect to your database. Refresh with the current structure of your database. […]
Having more than one email drafts saved in your mail app on your iPhone or iPad? Here is how you can get access to it very easily and quickly. Hold down the Compose icon in the lower right corner of your screen, and it’ll quickly jump to a list of your drafts. I use this feature all the time.
I wish I’d known about it sooner. When you’re typing in a web address, just hold down the “.” at the bottom of your keyboard, and a menu will pop up showing a list of web suffixes (.com, .net, .edu, etc.)
It can get annoying when you’re trying to take a picture and your iPhone camera keeps refocusing and automatically adjusting the exposure. Do you know that you can actually lock both auto-focus and exposure until you are done with a picture? Press and hold your finger on the screen until you see a yellow square blink twice. A yellow icon that says […]
Do you know that you don’t have to tap the capture button on your screen to snap a picture? You can actually just press the volume up/down button. That’s just much easier, isn’t it? Also, do you know you can take multiple photo bursts all at once by simply holding down the capture button or the volume up/down button? your phone […]
If you like to doze off with music playing, you can use the timer to automatically turn your music off so that it doesn’t play all night. In the timer app, tap When Timer Ends → scroll down to the bottom and tap Stop Playing. The Timer will automatically turn off your tunes after whatever length of time you set.
By default, you only get notified when you have new mails arrived in your inbox. If you have a rule set up in your mailbox that skips certain emails to one of your sub-folders, you won’t get notified on your iPhone or iPad when these emails arrived. Here is how you can change it to have these sub-folders also enabled […]