azunoman wrote:
what is your MySQL connection collation? via phpmyadmin...it should work with utf8_unicode_ci..but there are other choices...
Hi Azunoman,
my MySQL connection collation is indeed utf8_unicode_ci
See the issue there:
http://cust04.shemzone.com/Then click on the penultimate horizontal menu " Avtorji" (meaning "Authors" in Slovenian), then click on the letter S or Š => same result.
Here is how I build the alphanumerical bar: (example for D to S)
Code:
for ($char=68;$char<=83;$char++){ //D to S
if (chr($char)==$letter){
echo " | <span style=\"font-weight:bold;color:#999;text-decoration:underline;\">".chr($char)."</span>";
}else{
if (getListWriterbyLetter(chr($char))>0){
echo (" | <a href='".$mm_action_url."index.php?option=com_virtuemart&Itemid=$Itemid&page=$modulename.browse&list_writers=".$list_writers."&letter=".chr($char)."' title='".chr($char)."'><span style=\"font-weight:bold;\">".chr($char)."</span></a>");
}else{
echo " | <span style=\"color:#999;\">".chr($char)."</span>";
}
}
}
and for the Slovenian character
Code:
//Slovenian only
if($slovenian){
$slovenianArr=array("Š");
foreach ($slovenianArr as $i => $value) {
if (($slovenianArr[0]==$letter)){
echo " | <span style=\"font-weight:bold;color:#999;text-decoration:underline;\">".$slovenianArr[0]."</span>";
}else{
if (getListWriterbyLetter($slovenianArr[0])>0){
echo (" | <a href='".$mm_action_url."index.php?option=com_virtuemart&Itemid=$Itemid&page=$modulename.browse&list_writers=".$list_writers."&letter=".$slovenianArr[0]."' title='".$slovenianArr[0]."'><span style=\"font-weight:bold;\">".$slovenianArr[0]."</span></a>");
}else{
echo " | <span style=\"color:#999;\">".$slovenianArr[0]."</span>";
}
}
}
}
And (a part of) the SQL query:
Code:
$query = "SELECT COUNT(DISTINCT #__{vm}_bookshop_writer.writer_id) as num_rows_writers ";
$query .= "FROM #__{vm}_bookshop_writer, #__{vm}_bookshop_product_writer_xref, #__{vm}_product ";
$query .= "WHERE #__{vm}_bookshop_product_writer_xref.writer_id = #__{vm}_bookshop_writer.writer_id ";
$query .= "AND #__{vm}_bookshop_product_writer_xref.product_id = #__{vm}_product.product_id ";
$query .= "AND #__{vm}_product.product_publish='Y' ";
$query .= "AND #__{vm}_bookshop_writer.writer_lastname LIKE '$string%' ";
I tried to collate differently but no success:
Code:
$query .= "AND #__{vm}_bookshop_writer.writer_lastname COLLATE cp1250_general_ci LIKE '$string%' ";
Any clue is welcome.
Regards
Shemzone
