Since upgrade, I can't edit some (not all) product descriptions -

[thelorus]

and the ones I want to edit are the ones that have suddenly appeared in a large font size and a different colour from the rest! Since the upgrade, most of my product descriptions have remained the same, and are editable. But the rogue ones are un-editable. If I adjust the font size and color, and click update, they still appear in the online catalogue as they did before I tried to change them. Any ideas please? Many thanks -

[picandnix]

your best start is to post a link and give more details of your upgrade.

[dbltoe]

You should also check if your database and language files have the same character set. utf8, or some other, but they should match.

[voluntaryist.only]

hi dbltoe & picandnix,
thanks for the replies guys here is the site location:
http://www.newzctest.brookwater.co.uk/
I had changed the utf8 to latin1 on both confige files, so did not expect to see the following entries, when i did a quick search for utf8 via the developer tool page, found this:

(on includes/functions/functions-general.php)

*/
  function charsetConvertWinToUtf8($string) {
    if (function_exists('iconv')) $string = iconv("Windows-1252", "ISO-8859-1//IGNORE", $string);
    $string = htmlentities($string, ENT_QUOTES, 'UTF-8');
    return $string;
  }
/**
 * Convert supplied string to/from entities between charsets, to sanitize data from payment gateway
 * @param $string
 * @return string
 */
  function charsetClean($string) {
    if (CHARSET == 'UTF-8') return $string;
    if (function_exists('iconv')) $string = iconv("Windows-1252", CHARSET . "//IGNORE", $string);
    $string = htmlentities($string, ENT_QUOTES, 'UTF-8');
    $string = html_entity_decode($string, ENT_QUOTES, CHARSET);
    return $string;
  }

is this a red herring? should i change the utf8 to latin1 (is that right btw, latin1 not latin-1?)

thanks in advance,

ps: should mention it is not all of the files, just a few here & there, but having to check every single file will take forever, (600+ items..... groan...)

[voluntaryist.only]

Hi dbltow,
i have checked the mysql files & the coding is: utf8_general_ci
there is obviously something I need to do about this should i change the database setting to latin1? (same as confige files) ?

thanks again in advance...

ps: just a further thought, if i do this the other sites using this DB would be affected right? I also have the database for piwik installed as well, (piwik btw is great & a snap to install, much, much better than google analytic, much more accurate too.)

[voluntaryist.only]

Ok,
problem solved, UTF8 in database (btw, can have individual databases' designated to different coding, did not know that) & UTF8 in configure files (admin & includes) the whole latin1 thing (for me at least) was a blind alley. thanks for help guys, nudgedme in the right direction.

regards to all,

VO