[SM-PLUGINS] Umlauts and Mysql queries

[Jon N. <qu...@li...>]

Hello all,

I just added il8n support to the abook_group plugin and I have been
getting it translated.  So far it is working with Spanish and French but
there is a problem with German.

The following query returns what is expected:

$query = sprintf("SELECT b.nickname,b.firstname,b.lastname,b.email FROM %s
  a, %s b WHERE a.owner='%s' %s AND a.nickname=b.nickname AND
a.addressgroup ='%s' AND a.type='%s' ORDER BY a.nickname asc",$thisTable,
$abookBackendsTable,$thisOwner,$ownerClause,$group,$abookBackendsSname);

$res = $this->dbh->query($query);

I think there might be a problem with the above line, but I am not sure. 
Below is a partial "var_dump($res);".  It is the begining of the dump
where I think the problem lies:

object(db_result)(3) {
    ["row_counter"]=> NULL
    ["dbh"]=> &object(db_mysql)(25) {
        ["prepare_tokens"]=> array(0) { }
        ["prepare_types"]=> array(0) { }
        ["num_rows"]=> array(1) {
            [6]=> int(0)
        }
I compared the DE dump to FR, ES and US and found really the only thing
different between them is the line:

    [6]=> int(0) = DE
    [6]=> int(1) = ES, FR, US

That's where I am lost.  I did change the name of the translated "Personal
address book" from "Persönliches Adressbuch" to "Personliches Adressbuch"
and it worked.  So I am figuring it is something with the umlaut.

A following:

$row = $res->fetchRow(DB_FETCHMODE_ASSOC);

returns NULL for a "var_dump($row);".

TIA,

Jon

-- 
Trooper Jon S. Nelson, Linux Certified Admin., CCNA
Pa. State Police, Bureau of Criminal Investigation
Computer Crimes Unit
Work: 610.344.4471 Cell/Page: 866.284.1603
jon...@st...