0
votes
2answers
889 views

Postgres client unable to detect UTF-8 database

Context I am deploying a Vagrant box for my development team, and have encountered a problem restoring UTF-8 collated dumps. I don't believe it is related to the now-infamous "UTF8" has no equivalent ...
0
votes
0answers
37 views

Confusion over field encoding settings, character_set_results and character_set_connection

I've been reading through the MySQL docs on character encodings recently but I'm getting hung up on character_set_results and character_set_connection. I understand that character_set_client tells ...
0
votes
1answer
45 views

Which string variables in mysql support utf-8?

I have a table that stores string from a user and is displayed in a web form. But as I see when the user inputs e.g. in a language of cyrilic alphabet (I assume is UTF-8) garbage are displayed back. I ...
2
votes
2answers
3k 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 ...