The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
It's been more then four years since I transformed the original Access Databas into a mySQL database. Now entering the databas (phpMyAdmin) I see two identical tables in the same data base.
Each table comes in two editions - one lowercase and the other large letters in each table name. Table contents are identical. I've taken a screenshot showing the table structure in the database and put it into Dropbox. Please see the image via this link. WhiplashInfo Help Forum databas image Thanks / Tomas
Each table comes in two editions - one lowercase and the other large letters in each table name. Table contents are identical. I've taken a screenshot showing the table structure in the database and put it into Dropbox. Please see the image via this link. WhiplashInfo Help Forum databas image Thanks / Tomas
Posted
Can't help on this one I'm afraid, is one set of table empty ?
Posted
I seem to recall that mysql has a setting that can force lower-case identifiers. Perhaps something got changed in the mysql server? Just guessing.
Posted
Originally posted by HuwR
Can't help on this one I'm afraid, is one set of table empty ?
No - both tables contain identical information. Se Screenshot showing duplicate tables