PHP

Forcing UTF-8 MySQL query results in PHP

Issuing the query below immediately after establishing the MySQL database connection forces UTF-8 responses to subsequent queries.

MSSQL strings truncated to 4096 characters in PHP

I found when retrieving long TEXT fields from an MSSQL database using PHP, that the response was truncated to 4096...

Convert Unix dates for export to Excel with PHP or MySQL

Its easy enough to export formatted dates as strings to a .csv file for Excel, but if you want to...

php/PDO access to MS SQL Server from Ubuntu 16.04 LTS Server

The replacement of a Ubuntu 10.04 LTS server with one running Ubuntu 16.04 LTS necessitated moving from the php mssql_*...

Backup MySQL website databases without mysqldump

To backup the underlying MySQL databases for websites (Joomla! WordPress etc) I usually ssh into the hosting server, run mysqldump,...