View MySQL Char Set encoding for your database

Published on Author JFLeave a comment

Quick reference: For Schemas: SELECT default_character_set_name FROM information_schema.SCHEMATA S WHERE schema_name = “schemaname”; For Tables: SELECT CCSA.character_set_name FROM information_schema.`TABLES` T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA WHERE CCSA.collation_name = T.table_collation AND T.table_schema = “schemaname” AND T.table_name = “tablename”; For Columns: SELECT character_set_name FROM information_schema.`COLUMNS` C WHERE table_schema = “schemaname” AND table_name = “tablename” AND column_name = “columnname”; Thanks, as… Continue reading View MySQL Char Set encoding for your database

WordPress Plugin Selection Criteria

Published on Author JFLeave a comment

Here are a few of my selection criteria for using WordPress Plugins for myself and for clients. You may occasionally see strange things on this site as I frequently test plugins and themes. What is the latest version of WordPress it supports? Does it have market penetration? Is it consistently updated? How long has it… Continue reading WordPress Plugin Selection Criteria

Retrieving website credentials stored by Chrome password manager

Published on Author JFLeave a comment

Google Chrome is great for easily managing credentials for the various sights you visit. For convenience, these passwords are stored in local file that you access through Chrome itself. Copy & Paste this into your Chrome URI: chrome://settings/passwords You will see a list of credentials which you can search. To view the password, click on the… Continue reading Retrieving website credentials stored by Chrome password manager

Drupal, AJAX, PHP and max_input_vars

Published on Author JFLeave a comment

While developing a fairly list heavy website using Drupal 7 we reached a point where the common AJAX interface was breaking with an unknown error. The error suggested it was the AJAX function itself that it was breaking. Foolishly, we spent untold hours trying different version of JQUERY and looking into client side code to… Continue reading Drupal, AJAX, PHP and max_input_vars

WordPress on IIS 7.x 404 Error

Published on Author JFLeave a comment

There can be many reasons  a 404 error is generated when combining Windows, IIS, PHP,  and WordPress. Many of you/us out there use our Windows machines exclusively for a variety of reasons ( most often because gaming is where it’s at on Windows and consoles are for the strange). Because of this, we also develop on these… Continue reading WordPress on IIS 7.x 404 Error

Using UBLOX U-Center and NAZE32 to connect to UBLOX-6M

Published on Author JF6 Comments

UPDATED: 2-15-2015 > Read through, with updates on the bottom Although my GPS unit worked out of the box, I did want to connect to it and poke around, as well as see if I should configure it as suggested by CleanFlight. I don’t own (yet) a USB to Serial converter (one is one the… Continue reading Using UBLOX U-Center and NAZE32 to connect to UBLOX-6M

Web Font WOFF MIME Types for IIS 7.5

Published on Author JFLeave a comment

Quick reference for adding .woff and .woff2 fonts to IIS 7.5 as MIME types. You can add the MIME type as a global, or for the specific website. For either, you can add it through IIS Manager or the respective XML config files (web.config, etc.). MIME Type Text: .woff = application/font-woff .woff2 = application/font-woff2 This example shows… Continue reading Web Font WOFF MIME Types for IIS 7.5