Search for a command to run...
Today I needed to create a database with SQL_ASCII encoding.
Here is the command I used:
CREATE DATABASE MyDB ENCODING 'SQL_ASCII' TEMPLATE template0;
I had to use template0 because template1 was set to UTF8.
I still need to dig in on the templates and what they are all about.
No comments yet. Be the first to comment.
After I upgraded to Windows 11, my Sublime Text right-click context menu disappeared. Putting this here for my future reference, and hope it helps the next person. Cheers! @echo off REM Add Sublime Text to Windows 11 Right-Click Context Menu REM Run ...
This post is short and sweet for now. I plan on adding more commands as I get more familiar with VIM. Today I wanted to search and replace text in a JSON file using VIM. Turns out it is rather easy. :%s/"login"/"username"/g In my situation I needed ...
This is a short and sweet post. I often will start a project by initializing my project with git locally: git init . I then went to GitHub and created the project there. I chose a license file since this was a public repository. That created the ini...
This morning, I struggled to get Guest Additions installed on my Ubuntu Server VBox, which I am going to use to prepare a codebase for migration to Linux. It has been a while since Digital Ocean droplets are inexpensive to fire up and use. Here are t...
Last 10 queries I had a situation where I wanted to check if some SQL changes I made were working properly. It involved a transaction with a bunch of queries. Yes I could verify the data but I wanted to visually see the queries that my scripts were g...