Incorrect display of UUID

[archroot]

Incorrect display of UUID

System information:

• Server: Paper-243 (MC: 1.14.4) (Implementing API version 1.14.4-R0.1-SNAPSHOT)
• Proxy: BungeeCord BotFilter v3.8.6-dev
• Plugin version: OnlineTime 2.0.2

[seyfahni]

This isn't a bug, I'm saving the UUID as binary for performance improvement and storage saving.
To properly display the uuid you can use:

SELECT `id`, HEX(`uuid`) AS `uuid`, `name`, `time` FROM `online_time`;

You can of course also create a VIEW for easier reading.

To select a certain entry by uuid you can do:

SELECT `id`, `name`, `time` FROM `online_time` WHERE `uuid` = UNHEX('xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx');