Hello Proios, Am Montag, den 08.09.2008, 09:21 +0300 schrieb John Proios:
> I have one problem with gnue and greek utf-8. > > Storing all data in Mysql and my database support utf-8. > If write data(greek) in field on gnue-form view and storing normally. > But if try to read the data from my database (F8), the gnue-form do it > search and the come back chars is incomprehensible. I've have had (and still have) many issues with international character sets and collations with the mysql Database so I understand your confusion. First I think you should have some general knowledge of the many different settings mysql allows. For an overview have a look at: http://dev.mysql.com/doc/refman/5.0/en/charset.html In general you can determine the current setting of a connection with: mysql> show variables like "char%"; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ As you can see you can determine the character set of the server, a database, client a connection... In fact you can even define a character set at table and column level. Some of these settings are merely defaults. To diagnose your issue correctly one would have to check the entire stack to see what went wrong. But a wild guess could be that the database and table was created with a default latin1 setting, GNUe provided UTF-8 data which got mapped to the corresponding latin1 characters within mysql and when you fetch, the latin1 data is converted to UTF-8. Maybe you could show us your: MySQL: my.conf GNUe: connections.conf [Carefull, rmeove all passwords] and the output of: mysql> show variables like "char%"; from an interactive mysql session. Also if you can copy the actual characters you wrote and the characters you received, they might also help in diagnosing the conversion issue. Cheers, David _______________________________________________ Gnue-dev mailing list [email protected] http://lists.gnu.org/mailman/listinfo/gnue-dev
