# Mediumint unsigned datatype showing in binary

**URL:** <https://forum.confluent.io/t/mediumint-unsigned-datatype-showing-in-binary/5184>\
**Category:** Kafka Streams\
**Created:** [1 June 2022 06:53 UTC](https://forum.confluent.io/t/mediumint-unsigned-datatype-showing-in-binary/5184 "2022-06-01T06:53:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![saurabhlam](https://avatars.discourse-cdn.com/v4/letter/s/e36b37/32.png) [@saurabhlam](https://forum.confluent.io/u/saurabhlam)\
**Post date:** [1 June 2022 06:53 UTC](https://forum.confluent.io/t/mediumint-unsigned-datatype-showing-in-binary/5184/1 "2022-06-01T06:53:05Z")

</div>

Hi

I am using debezium connector to capture data from mysql and ship to kafka topic. But I am facing one issue. mediumint unsighned datatype values are showing in binary format. How to convert mediumint unsigned values to string or integer. Please suggest to resolve the issue.

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![bbejeck](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/bbejeck/32/412_2.png) [@bbejeck](https://forum.confluent.io/u/bbejeck)\
**Post date:** [2 June 2022 15:16 UTC](https://forum.confluent.io/t/mediumint-unsigned-datatype-showing-in-binary/5184/2 "2022-06-02T15:16:54Z")

</div>

Hi @saurabhlam - sounds like you want to try a [Cast Transform](https://docs.confluent.io/platform/current/connect/transforms/cast.html#cast) maybe? Also, you posted the question in the Kafka Streams section - I’d also post it on the [Kafka Connect](https://forum.confluent.io/c/kafka-connect/9) board.

HTH,  
Bill

---

<div class="post-metadata">

**Author:** ![saurabhlam](https://avatars.discourse-cdn.com/v4/letter/s/e36b37/32.png) [@saurabhlam](https://forum.confluent.io/u/saurabhlam)\
**Post date:** [2 June 2022 15:34 UTC](https://forum.confluent.io/t/mediumint-unsigned-datatype-showing-in-binary/5184/3 "2022-06-02T15:34:01Z")

</div>

Hmm, I dont know how to cast but in my table few columns data type is mediumint unsigned and values of that columns are coming in binary format.  
I have handled decimal value by changing mode to string but dont know how to handle these datatypes.

I have used below in debezium connector  
“decimal.handling.mode”: “string”,  
“bigint.unsigned.handling.mode”: “long”,  
“time.precision.mode”: “adaptive\_time\_microseconds”,  
“binary.handling.mode”: “base64”,

Will appreciate if get solution to handle mediumint unsigned datatype.