[Dolibarr-bugtrack] [bug #28317] sql query crash when you use especials char

[anakein]

URL:
  <http://savannah.nongnu.org/bugs/?28317>

                 Summary: sql query crash when you use especials char
                 Project: Dolibarr
            Submitted by: anakein
            Submitted on: Wed Dec 16 23:40:49 2009
                Severity: 3 - Normal
                  Status: None
                 Privacy: Public
             Assigned to: None
             Open/Closed: Open
         Discussion Lock: Any
                 Release: 2.7.0
        Operating System: GNU/Linux

    _______________________________________________________

Details:

in client screen if you put specials char, when you click search icon, crash
sql query.

this is the error:

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean
given in C:\wamp\www\dolibar26\htdocs\lib\databases\mysqli.lib.php on line
452
Dolibarr ha detectado un error técnico.
He aquí la información que podrá ayudar al diagnóstico:
Dolibarr: 2.7.0
Fecha: 20091217003724
Nivel de funciones: 0
Server: Apache/2.2.8 (Win32) PHP/5.2.4
Referer:
http://84.122.0.53/dolibar26/htdocs/comm/clients.php?leftmenu=customers
Url solicitada:
/dolibar26/htdocs/comm/clients.php?search_nom=do%C3%B1a&search_ville=&search_code=&x=6&y=7
Gestor de menú: eldy_backoffice.php/eldy_backoffice.php

Tipo de gestor de base de datos: mysqli
Petición último acceso a la base de datos erroneo: SELECT s.rowid, s.nom,
s.ville, st.libelle as stcomm, s.prefix_comm, s.code_client,
unix_timestamp(s.datec) as datec, unix_timestamp(s.datea) as datea FROM
llx_societe as s, llx_c_stcomm as st WHERE s.fk_stcomm = st.id AND s.client=1
AND s.entity = 1 AND s.nom like '%do�a%' ORDER BY s.nom ASC LIMIT 101
Código devuelto último acceso a la base de datos erroneo: DB_ERROR_1267
Información sobre el último acceso a la base de datos erroneo: Illegal mix
of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for
operation 'like'

search string is "doña" and query change specials char "ñ" for strange
char.




    _______________________________________________________

Reply to this item at:

  <http://savannah.nongnu.org/bugs/?28317>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.nongnu.org/