All Questions
7 questions
1
vote
1
answer
54
views
MySQL: using NAME_CONST internally
I'm using MySQL 8.0.32
I have some questions about an internal conversion, that I don't understand. In addition to this, sometimes this conversion is shown in SHOW FULL PROCESSLIST, as its execution ...
- 153
0
votes
2
answers
37
views
List of characters managed by a collation
I'm migrating to MySQL 8.0.33. We are changing character set to utf8mb4.
For collation, I'm wondering among different options.
I'm looking for documentation to review the list of characters that are &...
- 153
1
vote
0
answers
275
views
How to correctly set the database, table, and column collation in MySQL?
Background
I am experiencing problems setting the collation in my local MySQL database I am using for a Drupal site I am developing. I attempted to create a local database with charset utf8mb4 and ...
- 111
0
votes
1
answer
1k
views
Modify Collation of a column
mysql Ver 8.0.25
Got this error in apache log:
Error query: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ...
- 121
3
votes
1
answer
4k
views
mysql: setting default default_collation_for_utf8mb4?
How to set the value for "default_collation_for_utf8mb4" to "utf8mb4_general_ci", globally , or when the mysql 8.0 server started ?
I tried
[mysqld]
init_connect='SET ...
- 141
4
votes
2
answers
1k
views
Does MySQL 8 ASCII vs utf8mb4_0900_ai_ci size differ when only using ASCII characters?
If I only use only ASCII characters, will VARCHAR (255) with utf8mb4_0900_ai_ci be larger on disk than VARCHAR (255) using ASCII?
- 177
0
votes
1
answer
74
views
MySql8 Trailing String comparison
I am planning an upgrade of a legacy MySQL5.6 Database to MYSQL8.0.19 database.
All my testing has been successful but have one issue preventing me from going live.
By default in MYSQL5.6 the ...
- 135