• From: VnOSS
  • Registered: 2004-09-04
  • Posts: 121

Topic: Using of UTF8 charset in MySQL 5.0.x

Hi all,
I'm trying 1.2.10 with UTF8 charset in MYSQL 5.0.17 :
1. All punbb tables are defined with "DEFAULT CHARSET=utf8" and "Collation = utf8_general_ci"
2. Added $db->query("SET NAMES 'UTF8'"); at end of include/dblayer/common_db.php (proposed by someone in this forum)
3. All data was saved as UTF8 charset and under phpMyAdmin I can view all data correctly.

Problems:
1. All forums are lossed. My board is empty. But in Control panel they are there, showed in UTF8 correctly.
2. I can not rebuild index (Forum Maintenance). When I click button nothing is displayed in browser and the tables are empty.

Any ideas about this ?

TIA,

[no signature]
  • From: VnOSS
  • Registered: 2004-09-04
  • Posts: 121

Re: Using of UTF8 charset in MySQL 5.0.x

More info: word field in table punbb_search_words was changed to varbinary(20).

[no signature]
  • From: VnOSS
  • Registered: 2004-09-04
  • Posts: 121

Re: Using of UTF8 charset in MySQL 5.0.x

More more info: viewtopic.php does not work sad It seems that the following query returns nothing !:

require PUN_ROOT.'include/parser.php';

$bg_switch = true;  // Used for switching background color in posts
$post_count = 0;    // Keep track of post numbers

// Retrieve the posts (and their respective poster/online status)
$result = $db->query('SELECT u.email, u.title, u.url, u.location, u.use_avatar, ....

So in page viewtopic I loss all topics sad

Any ideas ?

[no signature]

4 Reply by mat

  • mat
  • Member
  • Offline
  • Registered: 2005-12-15
  • Posts: 40

Re: Using of UTF8 charset in MySQL 5.0.x

maybe this will help: http://punbb.org/forums/viewtopic.php?pid=19738#p19738

it sure works for my forum, read the whole thread..

mat's Website

  • From: VnOSS
  • Registered: 2004-09-04
  • Posts: 121

Re: Using of UTF8 charset in MySQL 5.0.x

It's ok now. I could "convert" punbb into full-utf8-support forum with MySQL 5.0.18 smile
Thanks,

[no signature]