# Limitation of Number of Characters in a value of a bin

**URL:** <https://discuss.aerospike.com/t/limitation-of-number-of-characters-in-a-value-of-a-bin/2472>\
**Category:** Feature Discussion\
**Created:** [February 5, 2016, 1:59pm UTC](https://discuss.aerospike.com/t/limitation-of-number-of-characters-in-a-value-of-a-bin/2472 "2016-02-05T13:59:20Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hafsa](https://avatars.discourse-cdn.com/v4/letter/h/0ea827/32.png) [@Hafsa](https://discuss.aerospike.com/u/Hafsa)\
**Post date:** [February 5, 2016, 1:59pm UTC](https://discuss.aerospike.com/t/limitation-of-number-of-characters-in-a-value-of-a-bin/2472/1 "2016-02-05T13:59:20Z")

</div>

Hello,

I have a set named ‘Profile’. ‘Profile’ has two bins: ‘name’ and ‘description’. Bin ‘description’ is not accepting characters more than 254. Can you please explain me about this limitation and how to extend this limitation?

By rephrasing a question: How long a string can be saved into aerospike. I have read in [http://www.aerospike.com/docs/guide/data-types.html](http://www.aerospike.com/docs/guide/data-types.html) that String can be arbitrary size bound by record size (128 KB). While, I am entering string with only 254 characters and it is not saving in Aerospike completely. It cuts the string.

I tried to fulfill my requirement by using complex datatypes also , but still getting cutted values in DB. Please guide me about details.

---

<div class="post-metadata">

**Author:** ![rbotzer](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/rbotzer/32/2114_2.png) [@rbotzer](https://discuss.aerospike.com/u/rbotzer)\
**Post date:** [February 5, 2016, 11:21pm UTC](https://discuss.aerospike.com/t/limitation-of-number-of-characters-in-a-value-of-a-bin/2472/2 "2016-02-05T23:21:53Z")

</div>

That sounds odd. Can you add some code to reproduce it, and state which client you’re using, its version, and which version of the server?

---

<div class="post-metadata">

**Author:** ![Hafsa](https://avatars.discourse-cdn.com/v4/letter/h/0ea827/32.png) [@Hafsa](https://discuss.aerospike.com/u/Hafsa)\
**Post date:** [February 8, 2016, 10:31am UTC](https://discuss.aerospike.com/t/limitation-of-number-of-characters-in-a-value-of-a-bin/2472/3 "2016-02-08T10:31:12Z")

</div>

I am using Aerospike-community 3.7.3. Scenario: I used the following command to enter a simple record in set ‘profile’:

`ascli put mguAnalytics profile hafsa '{"name":"hafsa","description":"User has set many levels in our system. She is an occasional user. Her profile is not completed and we need to communicate with her. She is also using shopping portal, shopping cart and mainly shop books. She has brought two users more but the are not active. She is also watching movies, main categories are : Thrill, fiction, drama and fantasy. She does not like horror stuff. She is notified by new releases of these genres."}'`.

It inserts the record without any error and when I used select \* to see the record, I get this result:

 ![](https://us1.discourse-cdn.com/flex019/uploads/aerospike/original/1X/36ab53b93da298ae4c3e02d2e88e4894e0fec3cc.jpg)

I am really looking forward to your help and suggestions.

---

<div class="post-metadata">

**Author:** ![rbotzer](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/rbotzer/32/2114_2.png) [@rbotzer](https://discuss.aerospike.com/u/rbotzer)\
**Post date:** [February 8, 2016, 2:47pm UTC](https://discuss.aerospike.com/t/limitation-of-number-of-characters-in-a-value-of-a-bin/2472/4 "2016-02-08T14:47:29Z")

</div>

If you read that record with any other client, for example the Python one, is the data actually truncated? It’s more likely that it’s a display issue in AQL. Are you using the latest tools package?

---

<div class="post-metadata">

**Author:** ![Hafsa](https://avatars.discourse-cdn.com/v4/letter/h/0ea827/32.png) [@Hafsa](https://discuss.aerospike.com/u/Hafsa)\
**Post date:** [February 8, 2016, 3:04pm UTC](https://discuss.aerospike.com/t/limitation-of-number-of-characters-in-a-value-of-a-bin/2472/5 "2016-02-08T15:04:50Z")

</div>

I am using NodeJS client to insert records in Aerospike for this task. From Nodejs client, its is truncated, then I test it with command line and get the same results. In aeropsike folder, I have this tool folder: aerospike-tools-3.7.3.ubuntu12.04.x86\_64.deb. Should I need to do any configuration settings or something else. Give me minutes to read the record from NodeJS client and then inform you.

---

<div class="post-metadata">

**Author:** ![Hafsa](https://avatars.discourse-cdn.com/v4/letter/h/0ea827/32.png) [@Hafsa](https://discuss.aerospike.com/u/Hafsa)\
**Post date:** [February 8, 2016, 3:12pm UTC](https://discuss.aerospike.com/t/limitation-of-number-of-characters-in-a-value-of-a-bin/2472/6 "2016-02-08T15:12:15Z")

</div>

I have read records through nodejs client and it is perfect NO TRUNCATION, yes you are right , it is a limitation of AQL. Thank you so much for your guidance.

---

<div class="post-metadata">

**Author:** ![Hafsa](https://avatars.discourse-cdn.com/v4/letter/h/0ea827/32.png) [@Hafsa](https://discuss.aerospike.com/u/Hafsa)\
**Post date:** [February 8, 2016, 3:14pm UTC](https://discuss.aerospike.com/t/limitation-of-number-of-characters-in-a-value-of-a-bin/2472/7 "2016-02-08T15:14:51Z")

</div>

Only a general question, Is there any limitation of long strings, JSON strings or no of items in a list by Aerospike? or can I send any size of string and any number of items in a list? Please guide me about this

---

<div class="post-metadata">

**Author:** ![rbotzer](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/rbotzer/32/2114_2.png) [@rbotzer](https://discuss.aerospike.com/u/rbotzer)\
**Post date:** [February 8, 2016, 3:44pm UTC](https://discuss.aerospike.com/t/limitation-of-number-of-characters-in-a-value-of-a-bin/2472/8 "2016-02-08T15:44:15Z")

</div>

There is no limit on the size of any bin, other than the [write-block-size](http://www.aerospike.com/docs/reference/configuration/#write-block-size) if your data is on disk. It can be one giant bin or any combination, as long as it fits. If the data is in memory there is no limit (though giant records will perform badly on the network).

Please check that you have [tools 3.7.3](http://www.aerospike.com/download/tools/3.7.3/) installed. It may fix the AQL bug you’re seeing.
