The differences in processing efficiency between MySQL’s three character storage types should not have a big impact on processing times unless your data sets are extremely large.

One of our clients has data on their internal SQL Server which they will be sending to our webserver periodically using the MySQL ODBC driver. In the testing we've done so far we've had problems ...