Skip to content

Instantly share code, notes, and snippets.

@0xMatt
0xMatt / sed-collation-issue-fixes
Created March 30, 2022 20:57 — forked from amurrell/sed-collation-issue-fixes
Fix collation and character set error from old mysql
# Unknown collation: 'utf8mb4_unicode_520_ci'
sed -i'.bak' "s/utf8mb4_unicode_520_ci/utf8mb4_unicode_ci/g;" file.sql
# COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4'
sed -i'.bak' "s/utf8_general_ci/utf8mb4_unicode_ci/g;" file.sql
<?php
$json = <<<JSON
{
"kind": "youtube#searchListResponse",
"etag": "\"I_8xdZu766_FSaexEaDXTIfEWc0/hys1HflQr8XiiYpydVnkJA-oudA\"",
"regionCode": "DE",
"pageInfo": {
"totalResults": 1,
"resultsPerPage": 5
},
@0xMatt
0xMatt / mortgageJavascript.html
Created January 31, 2016 23:24 — forked from anonymous/mortgageJavascript.html
theomega76PHP-HELL
<!DOCTYPE html>
<html>
<head>
<title>Theomega76| Mortgage Table with Inputs</title>
<meta charset="utf-8" />
<!-- Move to bottom later on for better performance -->
<script src="js/jquery-1.11.2.js"></script>
</head>