Tagged Questions
0
votes
2answers
67 views
How do I find an invalid utf8 character “somewhere” in my MySQL/trac database
I have an installation of trac, which uses MySQL. It has been upgraded so many times, moved servers etc. and chances are that the MySQL character sets were not always set correctly or consistently ...
2
votes
1answer
74 views
How can I disable utf8mb4 entirely on MySQL 5.5?
I know you're not supposed to do this, but I have a MySQL 5.5 master and a MySQL 5.1 replication slave. That's supposed to be okay, unless I do something stupid like use utf8mb4 that isn't supported ...
0
votes
1answer
34 views
é being converted from database to site
I have a MySQL database that is storing business data... In the database, when running a select against a business name that contains an accented e (é), it comes up correctly (showing me that it is ...
1
vote
2answers
165 views
Tell MySQL to start using utf-8 encoding without `convert to`ing it
In a fairly unique situation, my team has ended up with UTF-8 bytes in a database that thinks the data is encoded as latin1.
At least, I'm 85% certain that this is the situation at hand.
For ...
1
vote
1answer
482 views
Why default character_set_server is latin1?
I am using MySQL 5.5 and when I show variables about charset, I have
+--------------------------+----------------------------+
| Variable_name | Value |
...
1
vote
1answer
332 views
MySQL: Illegal mix of collations
I've tried using a stored procedure to create indices, and got the following error:
ERROR 1267 (HY000): Illegal mix of collations (utf8_general_ci,IMPLICIT) and
...
1
vote
1answer
543 views
Solutions to 4-byte utf-8 characters in mysql 5.1
I'm running into a problem that seems to be an issue w/ mysql 5.1s limitations on UTF8 characters.
From http://dev.mysql.com/doc/refman/5.1/en/charset-unicode-utf8.html
Currently, MySQL support for ...
