MySQL Character sets, Servoy and php

Classic Servoy
1

When insering character like <‘> or , etc in a text field, the values are correctly displayed in Servoy but are not read correctly from other apps accessing mysql.
For instance, if I connect to mysql using CocoaMySQL, all the <’> (the apostrophe character) becomes a and so on.
Since the table I’m working on must be read with php, is there a mysql setting that can solve the problem?

PS I had the same problem dumping a mysql database, recreating it on a different location and re-opening with servoy: all the special characters were gone.

2

I am not sure but can this have something to do with the encoding the database uses and servoy uses?

3

IT2BE:
I am not sure but can this have something to do with the encoding the database uses and servoy uses?

I think so. If I remember well, Servoy uses Unicode. But is there a way to set up MySQL to use unicode as well?

4

Servoy uses unicode internally (unicode is the only charset which can encode all other charsets), the databases uses a char encoding (depended on its settings) and the database driver converts Servoy unicode to the char encoding the database wants.
So in all cases the databasedriver must talk in the encoding the database is using, we suggest to use unicode also in the database to prevent any conflicts when distributing databases anywhere on the world

5

mysql can only use UTF from 4.1 (still alpha) see for example this link:
http://www.linuxforum.com/mysql/manual_Charset.html

6

jcompagner:
mysql can only use UTF from 4.1 (still alpha) see for example this link:
http://www.linuxforum.com/mysql/manual_Charset.html

I see. Thanks.

Btw: will Sybase support Unicode?

7

Yes, it is a choice when you define the database…