Conky Weather Revisited V2 - Page 28 - Ubuntu Forums:: 10 posts - Last post: Feb 15, 2008Page 28- Conky Weather Revisited V2 Desktop Effects & Customization. 1175 gap_y 25 # Force UTF8? note that UTF8 support required XFT http://ubuntuforums.org/showthread.php?t=666842&page=28HOME | I was having problems with certain Latvian characters - lowercase "ā","č" and "ō", to be specific.
It is due to the configuration of my server and database, as I tested these characters on different public pixelpost blogs and they were working correctly (sorry for spam). Land of Zoho Creator ยป Wufoo Themes Revisited:: most browsers would support and AppJet came to the rescue in about 10 lines of code: calScript.charset = 'utf-8'; // etc., etc.. No fuss, no muss. http://landofzohocreator.com/2008/01/04/wufoo-themes-revisited/HOME | [OSM-dev] Planet diff's revisited:: Jul 26, 2007 It is a nice piece of work (although the UTF8 sanitizer could Next message: [OSM-dev] Planet diff's revisited; Messages sorted by: http://lists.openstreetmap.org/pipermail/dev/2007-July/005895.htmlHOME |
In the end I found a solution, I added some lines to functions.php file:
Before
if(!mysql_connect($pixelpost_db_host, $pixelpost_db_user, $pixelpost_db_pass)) {
if($request_uri == 'admin') {
header("Location: install.php?view=db_fix");
exit;
}else{
show_splash("Connect DB Error: ". mysql_error()." Cause #2",$dir);
}
}
After
if(!mysql_connect($pixelpost_db_host, $pixelpost_db_user, $pixelpost_db_pass)) {
if($request_uri == 'admin') {
header("Location: install.php?view=db_fix");
exit;
}else{
show_splash("Connect DB Error: ". mysql_error()." Cause #2",$dir);
}
} else {
mysql_query("SET NAMES 'utf8'");
}
Could someone form devs check out this and maybe include it in codebase as it seems pretty safe change?
These issues were also for version 1.5 and 1.6.
Till today there was no case with SET NAMES issue as this should be DB encoding independent so please check if there is any other solution.
It should work without this change and without any problem.
I am quite sure that this is the only working solution. Spent some hours debbuging this, before I found that my blogging platform Textpattern does this after connecting to database. I see this as my server configuration fault (running some dozens of sites), but pixelpost should be as portable as possible.
This was also issue for versions 1.5 and 1.6 and was left unfixed (did not report it at that time).
Nortel Unveils Vision, Strategy for Israeli High-Performance Net
Busy Friday Leads to Strong Close for Net Stocks
|