for all those who have to deal with the same issue
Writing this is almost like posting in an open source forum with the difference that we all paid for this extension ...
Anyway.
After some tries I found a solution which works with UTF-8 as far as I checked it.
In the subdirectory /Connections there is the file "PowerCMSConnection.php" which contains the following code:
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_PowerCMSConnection = "myhost";
$database_PowerCMSConnection = "mydatabase";
$username_PowerCMSConnection = "myuser";
$password_PowerCMSConnection = "mypassword";
$PowerCMSConnection = mysql_pconnect($hostname_PowerCMSConnection, $username_PowerCMSConnection, $password_PowerCMSConnection) or trigger_error(mysql_error(),E_USER_ERROR);
// make sure UTF-8 is connected correctly
$result0 = mysql_query('SET NAMES utf8');
if (!$result0) {
die('invalid request: ' . mysql_error());
}
?>
It seems that "SET NAMES utf8" does the trick. What else needs to be done is changing all the wrong latin-1 collition settings in the database tables starting with "pcms2_" and wa_settings. Please tell me if I missed something.
Guys, could you fix this in an update?
PS.: Web-assist developers:
can you check your files in the /install/scripts/ folder?
db.sql file contains the latin1 settings
I hope this extension does not go up in price as it truly supports UTF-8 now ;-) since Eric wrote "Currently support for the UTF characters and other high level ASCII characters is not available by default."