Notifications
Clear all

Charset configuration of database connection

4 Posts
2 Users
0 Reactions
1,393 Views
(@julie)
Posts: 2
New Member
Topic starter
 

URL to your eFiction: http://budec.net/povidky/
Version of eFiction: 3.5
Have you bridged eFiction, if so with what?: no
Version of PHP: PHP 5.3
Version of MySQL: 5.5
Have you searched for your problem: yes
If so, what terms did you try: charset, mysql, database connect, dbconfig.php
State the nature of your problem:

My hosting provider upgrade to new version of MySQL and it destroyed charectes display. According provider I need to add expresion mysql_query("SET CHARACTER SET cp1250"); into a file for databese conection, so connection would have a correct charset configuration. My problem is, that I don't know, where to put this line and I'm not even sure if the expression is correct. I tryed config and dbconfig file, but it didn't work.
Do you have a test account for us? I don't think it's neccessary, but can be done.

Thank you in advance for your help!


 
Posted : 28/01/2012 10:44 am
(@lyndsie)
Posts: 1263
Member Moderator
 

Do you have a test site set up? I think I know where it might go, but I don't have a chance to test it.


 
Posted : 06/03/2012 9:50 pm
(@julie)
Posts: 2
New Member
Topic starter
 

Sorry for late answer. I'm afraid, I don't have a testing site ( know, bad policy). But I have backups, so I can test o production site.


 
Posted : 06/05/2012 7:17 am
(@lyndsie)
Posts: 1263
Member Moderator
 

Okay, I think you would add this after

mysql_select_db($dbname, $mysql_access);

In the dbconnect function in includes > mysql_functions.php

BUT BE VERY CAREFUL! I wouldn't test this in a live environment. That's the main MySQL query for everything, so if it's broken it will break the site. It may also not be the only instance where it would be needed; it's been a while since I looked at that.


 
Posted : 28/05/2012 1:54 am
Share: