PHPUnit - assertTablesEqual encoding accents

Question

I'm using: PHPUnit 3.6.12 / PHP 5.3.1 / MySQL 5.1.30

I'm trying to compare the value inserted by a function in a database with the value I expect.
The value is a string CONTAINING ACCENTS.

So I created a xml file: expectedValue.xml (file encoded in UTF-8)

<?xml version="1.0" encoding="UTF-8"?>
<dataset>
    <table name="MyTable">
        <column>MyColumn</column>
        <row>
            <value>résumé</value>
        </row>
    </table>
</dataset>

Here is the code in the test method (file encoded in UTF-8 too)

public function testSave()
{
    // this function saves the data in an UTF-8 database
    save('résumé');     

    $queryTable = $this->getConnection()->createQueryTable('MyTable', 'SELECT MyColumn FROM MyTable') ;
    $expectedTable = $this->createXMLDataSet('expectedValue.xml)->getTable('MyTable') ;

    $this->assertTablesEqual($expectedTable, $queryTable) ;
}

And here is the result I get:

Failed asserting that

MYTable
MyColumn
résumé

is equal to expected
MyTable
MyColumn
rÃ©sumÃ©

Does anyone know where this encoding problem may come from ??
Thanks !!

bashaus · Accepted Answer · 2013-10-26 18:28:49Z

2

Could possibly be the database connection

When you're connecting to MySQL (in your getConnection() method), you need to make sure you explicitly set UTF-8.

$pdo = new PDO( 
    'mysql:host=hostname;dbname=defaultDbName', 
    'username', 
    'password', 
    array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8") 
);

If you're not using MySQL, you can search for ways to set the charset.

edited Oct 26, 2013 at 18:28

answered Oct 26, 2013 at 18:21

bashaus

1,7132 gold badges17 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHPUnit - assertTablesEqual encoding accents

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related