[turba] mysql fields with accent

[James GONCALVES]

Hi Chuck,

When I use the field "prénom", I've the screen that you can see in the attachment
of this mail.

In the mysql log I've this :
18:29:17	    992 Connect     acp at 192.168.0.6 on
		    992 Init DB     annuaire
		    992 Init DB     annuaire
		    992 Query       SELECT id, nom, E_mail, organisation, prénom
FROM annuaire WHERE  (LOWER(nom) LIKE LOWER('%vial%'))

The field "prénom" has become prénom.

Thanks for your help.

James Goncalves




Chuck Hagenbuch (chuck at horde.org) écrivait:
>
>Quoting James GONCALVES <acp.informatique.support1 at wanadoo.fr>:
>
>> I have tried to connect a mysql database as addressbook. It works fine only
>> if the sources.php files I don't use some fields whose names have some special
>> characters like "prénom".
>
>Can you be a bit more specific about what doesn't work? Are you getting error
>messages, is there anything in your MySQL logs? It's possible there's something
>that we need to quote/encode in the SQL driver.
>
>-chuck
>
>
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: turbarecherche.jpg
Type: image/pjpeg
Size: 36705 bytes
Desc: not available
Url : http://lists.horde.org/archives/turba/attachments/20031003/81867d8c/turbarecherche-0001.bin