mysql - 如何本地化数据库中的错误消息

Question

在数据库上执行语句(CREATE/UPDATE/DROP/INSERT)后，有没有办法可以本地化数据库抛出的错误消息(如果有)，并将其显示在 UI 上？

Answer 1

事实上，是的，你可以做到。

根据MySQL docs :

lc_messages can be set at server startup and has global and session values that can be modified at runtime. Thus, the error message language can be changed while the server is running, and each client can have its own error message language by setting its session lc_messages value to the desired locale name. For example, if the server is using the fr_FR locale for error messages, a client can execute this statement to receive error messages in English:

SET lc_messages = 'en_US'

刚刚尝试了一下，确实有效!