[turba] Re: mysql fields with accent

[John Dalbec]

You may want to check out this thread on the IMP list.
http://marc.theaimsgroup.com/?l=imp&m=106543579221635&w=2
John

James GONCALVES wrote:

> 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
>>
>>
> 
>>
> 
> 
> ------------------------------------------------------------------------
> 
> 
> ------------------------------------------------------------------------
> 
>