I wrote a little PHP script that shows data from any table in an HTML table, and I had a little frustration in trying to keep the HTML table and column widths fixed.  I wanted to do this, because I want very large tables to appear to load very quickly, and not have columns “jump” … Continue reading How to keep fixed width HTML tables/columns fixed

I’m using Apache OpenOffice Base 4 with MySQL 5.6.  I noticed some question marks appeared where I should have seen some non-English characters (inuit characters).  I had set up the database properly to use UTF-8.  But, it turned out I used the ANSI ODBC driver.  Switching to the Unicode Driver easily fixed the problem.

So, I had a weird error with MySQL 5.6 Win 64 server.  Every time I tried to insert a record, I got an error that a field didn’t have a default value.  I was using Apache OpenOffice, with an ODBC driver, but the same underlying problem occurred with MySQL WorkBench, so it was a MySQL … Continue reading MySQL can’t insert without default val on auto-increment