I am in the middle of copying an old DB from a system on MSSQL to a new system on MySQL DB type.
Their old tables had a column as primary key that was 25 char varchar column. It works fine but I noticed there are 5 duplicate rows base on the fact that in the old MSSQL they had all caps on one and all smalls on the other. In MySQL it doesn't understand this is seems, and it marks it as duplicate. Is this true, is there a way around it? Thanks.