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