FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » General » Database discussions » Is it possible to set character_set_results ... for mysql 5.0... from fudforum code?
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Is it possible to set character_set_results ... for mysql 5.0... from fudforum code? [message #31875] Mon, 22 May 2006 04:16 Go to next message
AleZ is currently offline  AleZ   Russian Federation
Messages: 2
Registered: May 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 04:18]

Report message to a moderator

Re: Is it possible to set character_set_results ... for mysql 5.0... from fudforum code? [message #31885 is a reply to message #31875] Mon, 22 May 2006 10:12 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Edit the admimport.php script and change the:
DEFAULT CHARA CTER SET latin1
line to
DEFAULT CHARA CTER SET koi8r

this should do the trick.


FUDforum Core Developer
Re: Is it possible to set character_set_results ... for mysql 5.0... from fudforum code? [message #31897 is a reply to message #31885] Mon, 22 May 2006 17:58 Go to previous message
AleZ is currently offline  AleZ   Russian Federation
Messages: 2
Registered: May 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Thanks!
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: FUDForum charset problems
Next Topic: Mysql 5.0.12
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 10 23:09:24 EST 2017

Total time taken to generate the page: 0.00744 seconds