Re: [GNUe-dev] Gnue and Greek UTF-8

[David Ayers]

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