[opencms-dev] UTF-8 in Title and NavText properties of resource types

[Panos Kavalagios]

Spyro,

    Thank you very much for your prompt reply. Indeed, I had a look in 
the thread with subject *"Bad encoding in properties on Opencms6"* and I 
have inserted the following two variables in *my.cnf *of the database:

# The MySQL server

[mysqld]


# Database character set

character_set_client     = utf8

character_set_server     = utf8


and after restarting the database you get the following result:

mysql> show variables like 'character_set%';

+--------------------------+--------------------------------------------------+

| Variable_name            | Value                                            |

+--------------------------+--------------------------------------------------+

| character_set_client     | utf8                                             |

| character_set_connection | utf8                                             |

| character_set_database   | latin1                                           |

| character_set_results    | utf8                                             |

| character_set_server     | utf8                                             |

| character_set_system     | utf8                                             |

| character_sets_dir       | /home/opencms/mysql-4.1.16/share/mysql/charsets/ |

+--------------------------+--------------------------------------------------+

7 rows in set (0.00 sec)


and everything works fine. UTF-8 text in the property values is respected.

Regards,
Panos

Spyros Michas wrote:
> Similar problems came up just a few weeks ago. Check the archives.
>
> Chances are you have not set up your database properly. Make sure that your
> tables' character set is UTF-8. Also remember that from Mysql 4.1.x and
> onwards, columns within the same table might have different character set
> than the table default.
>
> Spyros Michas
>
>
> ------Original Mail------
> From: "Panos Kavalagios" <Panagiotis.Kavalagios at eurodyn.com>
> To: "The OpenCms mailing list" <opencms-dev at opencms.org>
> Sent: Thu, 26 Jan 2006 18:04:14 +0200
> Subject: Re: [opencms-dev] UTF-8 in Title and NavText properties of resource
> types
>
> Sorry,
>
>     The problem better written as: when you try to enter Eastern 
> European language in the Title or NavText property of any resource type 
> you see question marks both in Explorer view of OpenCms and on your 
> browser if you click on the resource.
>
> Panos Kavalagios wrote:
>   
>> Dear all,
>>
>>    I would like your guidance on the following problem. I'm using 
>> OpenCms 6.0.3 on Linux with Java 1.5.0 , Tomcat 5.5.12 and MySQL 
>> 4.1.16. While trying to create a multi-language content everything 
>> works fine and it is displayed correctly, but when you try to enter 
>> Greek or other Eastern European language set you get all your 
>> non-English characters replaced by '?'.
>>
>>    I have already put everywhere the property content-encoding to 
>> UTF-8 to html and jsp temlate files and in jsp files I have already 
>> used pageEncoding="UTF-8" directive to no avail. The same result you 
>> get if you try to use templateone template and for all resource types.
>>
>>  This is a very series problem, since it disables the possibility to 
>> have a multi-language site. You cannot have only multi-language 
>> content, you will also need localised site navigation.
>>
>> Kind regards,
>>
>>     
-- 
Panagiotis Th. Kavalagios
Electrical & Computer Engineer
European Dynamics S.A.
Athens, Hellas
Tel: +30-210-8094500

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20060127/da7d573e/attachment.htm>