GIGJ.COM
welcome to my space
X
Search:  
Welcome to:gigj.com
NAVIGATION - HOME
UTF support revisited
Published by: admin 2009-01-07

  • 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=28
    HOME
    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.html
    HOME

    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

    You are looking at:gigj.com's UTF support revisited, click gigj.com to home
    #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about UTF support revisited , Please add it free.
  • do you think tattoos on women are y or trashy
  • would you shave your head for 100k
  • guys how do you feel about women with tattoos
  • what is your concept of love
  • why are there crow bars but no bars for robins or pigeons
  • what do men think of women that drink and have tattoos
  • i like a boy a lot
  • what do you think about women and tattoos
  • why do women get that tattoos in the same spot
  • can you slap yourself right this second and say that it didn 039 t hurt
  • do i have razor burn
  • men out there what is your opinion on women having tattoos
  • fashion help help please
  • guys what do you think about tattoos on women
  • do women find guys with tattoos attractive
  • best hair products for volumizing hair available at discount drug stores
  • is this normal during pregnancy
  • hey i 039 m bored would someone really cool txt me
  • is it too late to start
  • a guy i know of said he was in the military but i dont believe him how can i check his full name to see
  • how do men feel about tattoos on women
  • why is it tattoos on women always seem to look nicer and of a higher quality to those on men
  • i 039 m applying for management position for hollister what is their policy on tattoos for women
  • poll hairy chest and arms or shaved
  • what to do with my hair pics
  • do a lot of women in boston area have tattoos
  • hi im 33weeks pregnant and had my first at 27weeks what should i be expecting now at this stage
  •  Homepage | Add to favorites | Contact us | Exchange links | LOGIN | Site map | 
    Copyright© 2008 gigj.com        Site made:CFZ