[turba] Re: mysql fields with accent

[Jan Schneider]

Zitat von John Dalbec <jpdalbec at ysu.edu>:

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

This has nothing to do with each other.

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

I can't remember what versions you're running. But if you're running cvs
code, you have a wrong setting for the db charset.

Jan.

--
http://www.horde.org - The Horde Project
http://www.ammma.de - discover your knowledge
http://www.tip4all.de - Deine private Tippgemeinschaft