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 to UTF8. 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-project.org --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
