vendredi 8 mai 2015

Database value being truncated at special character

I've exported my database from MySQL Workbench locally and I've just tried to run it on my live server and everything inserts successfully.

Some of the fields are being truncated whenever there is a special character, so 'This is a £ test' becomes 'This is a '.

I'm assuming this is an encoding issue however both the database on live and local have UTF8_unicode_CI as the collation.

Any ideas? Thanks

Aucun commentaire:

Enregistrer un commentaire