I have an MySQL 5.1 database which is set up to use Unicode (utf8) charactersets and collections.
I have uploaded an approximately equal symbol (Shmax ≈ Shmin) and when I view it in my first table it looks fine.
We then use an insert command ( Java and uses Hibernate API for persistence) to transfer the data to a second table which has also been set up with utf8 collections but when I view this table after the data transfer the data has now become Shmax ? Shmin
Can anyone tell me what is causing this behaviour and how I can get around it.