It's now clearly linked with some piece of configuration, as it works in Production, not in Dev. As we work on windows and the production is on linux, I have some ideas where to look at.
On 13 mar, 09:39, tonio607 <[email protected]> wrote: > I have a Doctrine_PgSql_Exception : > > SQLSTATE[22021]: Character not in repertoire: 7 ERREUR: séquence > d'octets invalide pour l'encodage «UTF8» : 0xe3a925 > HINT: Cette erreur peut aussi survenir si la séquence d'octets ne > correspond pas > au jeu de caractères attendu par le serveur, le jeu étant contrôlé par > « client_encoding ». > > Client_encoding in Pgsql is set toUTF8. > > On 12 mar, 22:23, Jonathan Wage <[email protected]> wrote: > > > What is the error you get with "$query->addWhere('LOWER(r.' . $field . ') > > LIKE ? ', '%ré%');"? > > > - Jon > > > On Thu, Mar 12, 2009 at 1:38 PM, tonio607 <[email protected]> wrote: > > > > Hello, > > > > There's nothing in google about doctrine and search for ut8 strings > > > like : > > > > $query->addWhere('LOWER(r.' . $field . ') LIKE ? ', '%ré%'); > > > > All my encoding settings are properly configured but then I got an > > > exception about the character é not found. > > > > And if I try to do for example : > > > > $query->addWhere('LOWER(r.' . $field . ') LIKE ? ', '%'.mb_strtolower > > > ('ré', 'utf-8').'%'); > > > > Then the é character is stripped so I got too much results. > > > > Does anybody have faced such problems ? Do I have forgotten something > > > in the encoding settings (files, symfony, doctrine encoding, etc.) ? > > > > Thanks > > > -- > > Jonathan H. Wage > > Open Source Software Developer & > > Evangelisthttp://www.jwage.comhttp://www.doctrine-project.orghttp://www.symfony... --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
