[Tickets #8777] Re: $conf['sql']['charset'] is ignored

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/8777
------------------------------------------------------------------------------
  Ticket             | 8777
  Updated By         | e.cerny at seznam.cz
  Summary            | $conf['sql']['charset'] is ignored
  Queue              | Horde Base
  Version            | 3.3.5
  Type               | Bug
  State              | Not A Bug
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


e.cerny at seznam.cz (2009-12-15 13:33) wrote:

But this way data in database are utf-8 overconverted from latin1 to  
utf8. So instead of "ěščřžýáíéžřč" there is  
"žřčšěščřžýáí"
1. if any other application uses this it is imposible to convert  
"žřčšěščřžýáí" to "ěščřžýáíéžřč"  
because there are ilegal latin1 characters.
2. backup, restoring and moving database is made problematic

I solved this with

         if ($dsn['charset']) {
             if (!@mysql_set_charset($dsn['charset'])) {
                 return $this->mysqlRaiseError();
             }
         }

added to pear/DB/mysql.php connect function after database conect

Which made PEAR function the old way

But this in not a permanent solution. The next "pear upgrade DB" will  
broke it again...