Is it possible to set character_set_results ... for mysql 5.0... from fudforum code? [message #31875] |
Mon, 22 May 2006 08:16 |
AleZ
Messages: 2 Registered: May 2006
Karma: 0
|
Junior Member |
|
|
Hi!
I use FudForum 2.7.4/koi8r with mysql 5.0.21 on a host.
mysql> use fud;
mysql> show variables like "character%";
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | koi8r |
| character_set_connection | koi8r |
| character_set_database | koi8r |
| character_set_filesystem | binary |
| character_set_results | koi8r |
| character_set_server | koi8r |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
I'm trying move forum on another host with mysql 5.0.21:
mysql> use fud;
mysql> show variables like "character%";
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | koi8r |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
Make datadump, install on new server fudforum, import forum data
and got a lot of '???????????' in the place koi8 chars.
Is it a pretty way to set mysql connection settings for fudforum and for adm procedures? I can't change default settings on the server. There are another users and applications. Is it enough
add the 'SET character_set....' near connect_func in db.inc's, index.php, pdf.php, rdf.php,... or I must to change forum dump too?
[Updated on: Mon, 22 May 2006 08:18] Report message to a moderator
|
|
|
|
|