Web lists-archives.com

Re: characters oddity




McGranaham, Jamen wrote:
Have two virtual machines, both running RedHat 7. Both are also running
MySQL 5.6.29 and both have the same data. We have two databases, however,
that keep throwing odd characters on one system but it's OK on the other and
we've not been able to figure out why.

What it should look like (from the test machine, pointing to the database on
the test machine):



What it looks like on our Production database (from the test machine,
pointing to the production database):
Décimas a la censura de Carmen Aristegui
Guillermo Velázquez Benavidez

We have verified the my.cnf is the same on both machines, using utf8 as the
default character set. We have also verified the character sets for the
databases and tables are identical. We know it has to be something with the
MySQL database on our Production server because we can point Production to
the Test database and it the characters are translated correctly. But we
just haven't been able to figure out what it is - and it's been 48 hours
worth of work and investigation. Any advice, guidance, or suggestions would
be greatly appreciated!  Thank you!

Jamen McGranahan
Systems Services Librarian
Vanderbilt University LIbrary
Central Library
Room 811
419 21st Avenue South
Nashville, TN 37214

-------------------------------------
How is the information going into the database.  We had character issues
until we delt with perl's UTF-8 conversion and also set the DBI to expect
UTF-8 characters.  Also the forms must be configured to send UTF-8
<form method="POST" accept-charset="UTF-8" action="...." >
$dbh= DBI->connect("dbi:mysql:$dbname",$dbuser,$dbpasswd,{ RaiseError =>
1,mysql_enable_utf8=>1})
What is strange, is when its not setup correctly some characters will go
in and out correctly but others won't.    Not sure if any of this will
help.

------
William R. Mussatto
Systems Engineer
http://www.csz.com
909-920-9154


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql