<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-7" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Spyro,<br>
<br>
Thank you very much for your prompt reply. Indeed, I had a look in
the thread with subject <b>"Bad encoding in properties on Opencms6"</b>
and I have inserted the following two variables in <b>my.cnf </b>of
the database:<br>
<br>
<pre><font color="#6600cc"># The MySQL server</font></pre>
<pre><font color="#6600cc">[mysqld]</font></pre>
<pre><font color="#6600cc">
# Database character set</font></pre>
<pre><font color="#6600cc">character_set_client = utf8</font></pre>
<pre><font color="#6600cc">character_set_server = utf8</font></pre>
<br>
and after restarting the database you get the following result:<br>
<br>
<pre><font color="#6600cc">mysql> show variables like 'character_set%';</font></pre>
<pre><font color="#6600cc">+--------------------------+--------------------------------------------------+</font></pre>
<pre><font color="#6600cc">| Variable_name | Value |</font></pre>
<pre><font color="#6600cc">+--------------------------+--------------------------------------------------+</font></pre>
<pre><font color="#6600cc">| character_set_client | utf8 |</font></pre>
<pre><font color="#6600cc">| character_set_connection | utf8 |</font></pre>
<pre><font color="#6600cc">| character_set_database | latin1 |</font></pre>
<pre><font color="#6600cc">| character_set_results | utf8 |</font></pre>
<pre><font color="#6600cc">| character_set_server | utf8 |</font></pre>
<pre><font color="#6600cc">| character_set_system | utf8 |</font></pre>
<pre><font color="#6600cc">| character_sets_dir | /home/opencms/mysql-4.1.16/share/mysql/charsets/ |</font></pre>
<pre><font color="#6600cc">+--------------------------+--------------------------------------------------+</font></pre>
<pre><font color="#6600cc">7 rows in set (0.00 sec)</font></pre>
<br>
and everything works fine. UTF-8 text in the property values is
respected.<br>
<br>
Regards,<br>
Panos<br>
<br>
Spyros Michas wrote:
<blockquote cite="mid3150785160.20060126185434@hydroex.gr" type="cite">
<pre wrap="">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" <a class="moz-txt-link-rfc2396E" href="mailto:Panagiotis.Kavalagios@eurodyn.com"><Panagiotis.Kavalagios@eurodyn.com></a>
To: "The OpenCms mailing list" <a class="moz-txt-link-rfc2396E" href="mailto:opencms-dev@opencms.org"><opencms-dev@opencms.org></a>
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:
</pre>
<blockquote type="cite">
<pre wrap="">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,
</pre>
</blockquote>
</blockquote>
<pre class="moz-signature" cols="72">--
Panagiotis Th. Kavalagios
Electrical & Computer Engineer
European Dynamics S.A.
Athens, Hellas
Tel: +30-210-8094500
</pre>
</body>
</html>