Hi,
in next version PiF 0.08.00 we will use utf-8 charset for the data which are stored in the database.
This may cause some errors if you already have PiF 0.07.00 installed.
For a clean installation it should work like a charm.
I already tested the new utf-8 charset on this site.
I used a script to convert the data from the existing database to utf-8.
I will attach it here in the post.
But I found out some errors:
a) In table "comments" the "comment_type" isn't 100% converted.
I used the following statements in PHPMyAdmin to make it work:
UPDATE YOURPREFIX_comments SET comment_type='r' WHERE comment_type='r\0'
UPDATE YOURPREFIX_comments SET comment_type='A' WHERE comment_type='A\0'
UPDATE YOURPREFIX_comments SET comment_type='N' WHERE comment_type='N\0'
UPDATE YOURPREFIX_comments SET comment_type='C' WHERE comment_type='C\0'
b) in table "admin" there is the same problem with "admin_rights".
I just deleted all admin rights and added them again.
I am not sure, but the issue could be the CHAR(4) in admin_rights and the CHAR(2) in comment_type.
When I create my database does it make any difference which utf8 collation option I select? I selected utf8_general_ci and all seemed to go well. Is this the correct selection for English
arat wrote:
When I create my database does it make any difference which utf8 collation option I select? I selected utf8_general_ci and all seemed to go well. Is this the correct selection for English
Yes, with this one all Locales/Languages should work as far as I know.
well... not all users are coders... i tryed to install 0.08, but i get only errors with the charsets.... well 0.07 was running fine... but with my little skills a can not figure out, whats going wrong... tested now 5 hours to get it workin and i dont want to stay in 0.07... well.. looks like, the newer versions are only for coders or php freaks... is there a fix planed or something to make it easier?... or better a step by step readme? im not a sql freak, i only know how to read, maybe edit something after a step by step instruction
I got the problem again with the latest updated of PiF
Is there a fix for this too?
http://nightwishbelgium.be/news.php you can see that the text isn't displayed properly
Notice: Use of undefined constant DB_NAME - assumed 'DB_NAME' in E:\xampp\htdocs\PiF\utf8-converter.php on line 48
Code
mysql_query("ALTER DATABASE " . DB_NAME . " CHARACTER SET utf8", $link_id);
Code
$DB_HOST = 'localhost'; // Enter your Database Host
$DB_USER = 'xxxx'; // Enter your Database Username
$DB_PASSWORD = 'xxxx'; // Enter your Database Password
$DB_DATABASE = 'PIF'; // Enter your Database Name
