Solved Storing a list of UUIDs in MySQL

Discussion in 'Plugin Development' started by Paul122, Apr 11, 2021.

Thread Status:
Not open for further replies.
  1. Offline

    Paul122

    Hey,

    I'm creating a teams plugin that should store a list of the members in UUID form with SQL. I've been serializing the list of UUIDs by converting them to a single string, each UUID being separated with a comma. This works well for just a few UUIDs, but if I try to serialize a list with 8+ members, the varchar will go over the length limit for MySQL. Does anyone have any suggestions on how I might go about getting around this?

    Thanks
     
  2. Online

    timtower Administrator Administrator Moderator

    @Paul122 Make a table teammembers
    First column is the team (which is in another table)
    Second column the uuid.
     
Thread Status:
Not open for further replies.

Share This Page