WebsiteBaker Support (2.10.x) > General Help & Support

Language issue with minislider

<< < (2/3) > >>

jacobi22:
i work in locale test's with mysql-strict mode and in this mode, the add.php doesnt insert the entry for this section, because, there is no value for the field "texts" (our description)

if i work in non-strict-mode, everything works. the cyrillic letters are saved correctly in my database and the frontend display everything correctly in cyrillic letters,


so maybe something goes wrong at your server, please check the database table mod_minislider and here specially the structure like my picture (specially the collation - here the german word "Kollation" and the entry for this section (pic #2), specially the content of field "texts"





do you change anything in the module like new nivoslider-javascript-files?

the view.php use htmlentities to "translate" special chars - red marked in my quote


--- Quote ---foreach($images as $img) {
      $text = isset($t[$i])? trim($t[$i]):'';
      echo '    <img src="'.$baseurl.$curdir.basename($img['file']).'" data-transition="'.$transition.'" title="'.htmlentities($text).'" alt="" />';
      $i++;
   }
--- End quote ---

you can try it without htmlentities like

foreach($images as $img) { 
$text = isset($t[$i])? trim($t[$i]):'';
echo '    <img src="'.$baseurl.$curdir.basename($img['file']).'" data-transition="'.$transition.'" title="'.$text.'" alt="" />'; 
$i++;
}


--- Quote ---Maybe I have to add somewhere in view.php UTF-8?
--- End quote ---

we need to know first, what you use as table collation in this table. best way to found it out - export this table as sql-file, then we know, whats happend in the database. it looks for me like a different collation at the moment, maybe latin1_general

rumen:
In the site Code table is UTF-8, in the host callation is utf8_general_ci  and some modules have utf8_general_ci  other have utf8_unicode_ci. I don't know if there is difference between utf8_general_ci and utf8_unicode_ci

rumen:
The text field in module minislider in PHP admin is full with
--- Code: ---?????????? ?????? ????????
--- End code ---


--- Code: ---????? ?? 1-???? ????????
????? ?? 2-???? ????????
????? ?? 3-???? ????????
????? ?? 4-???? ????????
--- End code ---

I will try to cjange it there :)

rumen:
And guess what ..... on the host minislider has collation - latin1_swedish_ci

jacobi22:

--- Quote ---The text field in module minislider in PHP admin is full with ........
--- End quote ---

its a translation problem, but dont use PHPmyAdmin to read the correct entry in sql-language. PHPmyAdmin is a browser and use the browser language settings to translate everything. if its not possible, to translate a char (maybe a unknow'n char are transmitted), the browser show's ???? for every char.

please use the sql-export, it show's the real entry in sql-language and without browser translation.


--- Quote ---difference between utf8_general_ci and utf8_unicode_ci
--- End quote ---
i'm not expert for this. unicode is better in result sorting and general is a little bit faster. both collations are allowed, so it doesnt matter


--- Quote ---And guess what ..... on the host minislider has collation - latin1_swedish_ci
--- End quote ---

you can change the collation to utf8_general_ci or utf8_unicode_ci  and add the description again

Navigation

[0] Message Index

[#] Next page

[*] Previous page