Questions tagged [utf-8]
Unicode variable-width character encoding (between 1 and 4 bytes per code point).
10
questions
12
votes
1
answer
48k
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 |
+--------------...
- 549
4
votes
2
answers
19k
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 example,...
- 151
19
votes
2
answers
54k
views
Set value of character_set_client to utf8mb4
I'm trying to convert my DB to utf8mb4 following this guide. I have set:
[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
[mysqld]
init-connect='SET NAMES utf8mb4'
...
- 295
10
votes
2
answers
8k
views
Upgrade all MySQL columns, tables, and databases from utf8mb3 to utf8mb4
I have thousands of columns across hundreds of tables in about a hundred databases inside a MySQL instance that need to be upgraded from utf8mb3 to utf8mb4. Is there a way to generate ALTER ...
6
votes
2
answers
15k
views
MySQL silently replaces UTF chars with literal question marks
I'm experiencing a situation similar to this SO question i.e. I'm working with a legacy database which has UTF8 content in latin1 tables (pretty ugly I know).
Now I'm getting new data from a new ...
- 169
5
votes
2
answers
6k
views
How to convert mysql database charset to utf-8
I have a vb forum with a huge amount of data
I need a way to convert this forum database tables charset with thier data from
latin1_swedish_ci to utf8-general-ci
How to do this ?
4
votes
1
answer
11k
views
Storing special characters (German, French, Spanish) in SQL Server result in weird strings
I'm trying to store the German ß in SQL Server, but it results in ß.
For example "Gleimstraße" is stored as "Gleimstraße"
But this also happens for other characters:
"König-...
- 245
3
votes
1
answer
977
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 ...
2
votes
1
answer
409
views
How can I detect double-encoded MySQL columns and rows, and validate the repair?
My database provider, bless their hearts, migrated our MySQL databases to another server recently, and introduced double-encoding of UTF-8 data via Latin1 into our text data. Strings like 'emdash—here'...
- 191
1
vote
2
answers
2k
views
"Incorrect string value" while migrating from MSSQL to MySQL with Workbench
I got the task to migrate our MSSQL database into a MySQL database.
Therefore I am using the recent version of MySQL Workbench and FreeTDS Driver.
During the migration I always get errors like this:
...
- 111