# Multi-value attributes and MariaDB **URL:** \ **Category:** Uncategorized\ **Created:** [April 13, 2023, 11:07am UTC](https://forum.tiledb.com/t/multi-value-attributes-and-mariadb/562 "2023-04-13T11:07:47Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![vkaramanis](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.tiledb.com/vkaramanis/32/263_2.png) [@vkaramanis](https://forum.tiledb.com/u/vkaramanis)\ **Post date:** [April 13, 2023, 11:07am UTC](https://forum.tiledb.com/t/multi-value-attributes-and-mariadb/562/1 "2023-04-13T11:07:48Z")
Hi, I have a TileDB array, initialized in python, which has a 3-value fixed-length attribute: dtype(“float32, float32, float32”) I have connected this array with a MariaDB server to run SQL queries, but when I am \* selecting the table, only the first of the three values is shown. Is there a way to fetch all values, as tuple/list or in different columns sequentially? Thanks, Viktor ---
**Author:** ![seth](https://avatars.discourse-cdn.com/v4/letter/s/f14d63/32.png) [@seth](https://forum.tiledb.com/u/seth)\ **Post date:** [April 14, 2023, 2:43pm UTC](https://forum.tiledb.com/t/multi-value-attributes-and-mariadb/562/2 "2023-04-14T14:43:04Z")
Hello @vkaramanis ! Thank you for posting about this. Today MariaDB doesn’t support fixed size (greater than 1 value) or var length numeric types. There is no “array” or other type which we can convert this value to natively in MariaDB. There are a few options that we could consider and would like your feedback on based on your intended use case. Option 1: We can encode the multi-value attribute in a csv or json for a string representation. This could be useful for printing out of the results but will incur overhead in the conversion and depending on what you are looking to do with the values might cause you to parse the data back into a vector/array after the query. Option 2: We can report these fields are blobs, and return the values as a raw sequence of bytes (12 bytes in your case) where at an application you could cast each blob to the appropriate datatype, i.e a numpy array of `dtype=[np.float, np.float, np.float]`. Option 3: For fixed-length attributes we can report each values as a separate column in MariaDB. i.e `attribute_1_value_1`, `attribute_1_value_2`, `attribute_1_value_3`. This semantics would let you use the values in MariaDB and perform operations but it will only work for fixed size values where the number of generated fields is known. Please let us know your use case and thoughts on which implementation would best align with your goals and we’ll make the changes and issue a new release in the next week. ---
**Author:** ![vkaramanis](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.tiledb.com/vkaramanis/32/263_2.png) [@vkaramanis](https://forum.tiledb.com/u/vkaramanis)\ **Post date:** [April 14, 2023, 3:58pm UTC](https://forum.tiledb.com/t/multi-value-attributes-and-mariadb/562/3 "2023-04-14T15:58:33Z")
> [@seth](#): > > blobs Hi @seth ! Thanks a lot for the reply and the willingness to help. 🙂 I think option 2 is most appropriate as it seems to be the most performant and general, so I can make any casting or column separation in a later stage. ---
**Author:** ![seth](https://avatars.discourse-cdn.com/v4/letter/s/f14d63/32.png) [@seth](https://forum.tiledb.com/u/seth)\ **Post date:** [April 14, 2023, 4:07pm UTC](https://forum.tiledb.com/t/multi-value-attributes-and-mariadb/562/4 "2023-04-14T16:07:02Z")
We will start working on option 2. @Dimitris_Staratzis will do the implementation and provide you with a status update next week. ---
**Author:** ![Dimitris\_Staratzis](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.tiledb.com/dimitris_staratzis/32/146_2.png) [@Dimitris\_Staratzis](https://forum.tiledb.com/u/Dimitris_Staratzis)\ **Post date:** [April 21, 2023, 5:19pm UTC](https://forum.tiledb.com/t/multi-value-attributes-and-mariadb/562/5 "2023-04-21T17:19:41Z")
Hi @vkaramanis, We have implemented a working prototype that retrieves the data correctly as a blob. We could not yet cast this data as a float or any other datatype in MariaDB itself but the bytes are correct and they work as expected if manipulated outside MariaDB. Example of casting we tried: `CAST(SUBSTRING(attribute, 1, 4) AS FLOAT)` I will come back early next week on this. ---
**Author:** ![Dimitris\_Staratzis](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.tiledb.com/dimitris_staratzis/32/146_2.png) [@Dimitris\_Staratzis](https://forum.tiledb.com/u/Dimitris_Staratzis)\ **Post date:** [April 27, 2023, 3:20pm UTC](https://forum.tiledb.com/t/multi-value-attributes-and-mariadb/562/6 "2023-04-27T15:20:23Z")
Hi @vkaramanis, we have released [TileDB-MariaDB 0.22.2](https://github.com/TileDB-Inc/TileDB-MariaDB/releases/tag/0.22.2). All fixed-length multi-value attributes will now be treated as blobs and will return a sequence of bytes. Best, Dimitris ---
**Author:** ![vkaramanis](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.tiledb.com/vkaramanis/32/263_2.png) [@vkaramanis](https://forum.tiledb.com/u/vkaramanis)\ **Post date:** [April 28, 2023, 9:16am UTC](https://forum.tiledb.com/t/multi-value-attributes-and-mariadb/562/7 "2023-04-28T09:16:51Z")
Thanks very much guys!! I will test it today and get back to you if anything pops up.