Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
S
S
Sergey Pugovkin2018-08-20 15:54:56
MySQL
Sergey Pugovkin, 2018-08-20 15:54:56

MySQL base, utf8mb4 encoding. What encoding to put for a string identifier?

The VARCHAR field is 255 long, which is too long for a utf8mb4-encoded index
Characters: a-z0-9_- Case insensitive
.
ascii_general_ci?
And is it true that the field only with Latin does not care at all with what encoding we connect to the database?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
S
SagePtr, 2018-08-20
@Driver86

Even more suitable is ascii_bin - which is case sensitive (identifier is the same)

Similar questions
M
Maxim Kudryavtsev2020-01-06 05:37:12
Why does Yandex.Mail give errors when fetching a message from a subdomain? 1Reply
A
awgur2015-09-04 15:33:02
How to set up a filter in RouterOS to forward one port to another? 4Reply
I
Ivan2017-08-13 20:34:18
How to fix site encoding in response to cURL request? 3Reply
A
alexalexov20192020-03-06 13:20:25
When I work for upwork through an agency, will my hours be kept after I leave the agency? 2Reply
X
xto_tbl_takou2017-11-28 18:10:56
How to be in this situation with js html and php? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question