Special Characters in MySQL Database

Indian Bikes to the latest Harleys and the amount of money being put into the work on the bikes was evident, with figures of 80,000

Hi, I have problem in inserting the above phrase in the database.

I use mysql5 as the backend to one of my Servoy solutions.

The table is set to utf8_general_ci

In the above quote you could see

  • the apostraphe is different than the normal one (')
  • there is Euro symbol

Servoy displays them perfectly when we enter the data. But after we restart Servoy everything after the apostraphe or the Euro symbol is stripped off.

When I open the table using the mysql control center I cannot see the data after the apostraphe

Any idea please?

Thanks