[Skip to main content](#vessel-content) # Custom Field and Truncation Issue ## - **[tspires](/forum/user/7391-tspires "View tspires's Profile")** - [![tspires's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7391-tspires "View tspires's Profile") Topic Author - [ Offline](/forum/user/7391-tspires) Less More - Posts: 18 - Thank you received: 3 - - 14 years 2 months ago [\#60477](#60477) by [tspires](/forum/user/7391-tspires "View tspires's Profile") *[Custom Field and Truncation Issue](/forum/3-bug-report/60477-custom-field-and-truncation-issue#60477 "On the Registration page, during check-out, I need to add a custom field--i.e. a single selection dropdown. The contents of the dropdown comprises over 1200 items. Unfortunately, a truncation effect...")* was created by *[tspires](/forum/user/7391-tspires "View tspires's Profile")* On the Registration page, during check-out, I need to add a custom field--i.e. a single selection dropdown. The contents of the dropdown comprises over 1200 items. Unfortunately, a truncation effect is happening--i.e. if I edit the Custom Field, the full list is not shown and the Title of the last item is truncated. From what I can tell, all 1200+ items are in the database and it looks like the data is stored in "field_value" in the "_hikashop_field" table as a single string where each item is separated by "::". Some of the items in the dropdown are very long. As I've been shortening them, I'm noticing this is allowing more rows to be seen in the dropdown. It's almost like there is a character count limit and I've exceeded it. I wasn't sure if this was a bug or not so I apologize if I posted in the wrong area. I'm hoping I can shrink enough of the items to get all to appear in the dropdown but this list will grow. Thanks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82MDQ3Ny1jdXN0b20tZmllbGQtYW5kLXRydW5jYXRpb24taXNzdWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 14 years 2 months ago [\#60500](#60500) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Custom Field and Truncation Issue](/forum/3-bug-report/60477-custom-field-and-truncation-issue#60500 "On the Registration page, during check-out, I need to add a custom field--i.e. a single selection dropdown. The contents of the dropdown comprises over 1200 items. Unfortunately, a truncation effect...")* Hi, That's because you reached the limit of the number of characters of the column where the values are stored in the database. We didn't think someone would enter so much data in there. You will need to go edit the table hikashop_field via phpmyadmin and change the type of the column field_value from "text" to "long text". That will allow you to enter all the data in that field. Also, you could directly enter all the field values directly from there. You would have to do some search and replace in a text editor and you should be able to get your list of values really rapidly in it. The following user(s) said Thank You: [tspires](/forum/user/7391-tspires "View tspires's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82MDQ3Ny1jdXN0b20tZmllbGQtYW5kLXRydW5jYXRpb24taXNzdWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[tspires](/forum/user/7391-tspires "View tspires's Profile")** - [![tspires's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7391-tspires "View tspires's Profile") Topic Author - [ Offline](/forum/user/7391-tspires) Less More - Posts: 18 - Thank you received: 3 - - 14 years 2 months ago [\#60514](#60514) by [tspires](/forum/user/7391-tspires "View tspires's Profile") Replied by *[tspires](/forum/user/7391-tspires "View tspires's Profile")* on topic *[Re: Custom Field and Truncation Issue](/forum/3-bug-report/60477-custom-field-and-truncation-issue#60514 "On the Registration page, during check-out, I need to add a custom field--i.e. a single selection dropdown. The contents of the dropdown comprises over 1200 items. Unfortunately, a truncation effect...")* > nicolas wrote: Hi, > > That's because you reached the limit of the number of characters of the column where the values are stored in the database. We didn't think someone would enter so much data in there. > You will need to go edit the table hikashop\_field via phpmyadmin and change the type of the column field\_value from "text" to "long text". > That will allow you to enter all the data in that field. > Also, you could directly enter all the field values directly from there. You would have to do some search and replace in a text editor and you should be able to get your list of values really rapidly in it. Hey nicolas, as always, thanks for the insight and assistance. We are needing customers to identify an entity with their order and the list of entities is quite extensive. As I said, I wasn't sure if it was a bug report or by design, though you've answered that question. I came close to changing the data type for that field but thought I'd wait to confirm it wasn't a bug. Change has been made and everything looks good! I use the old MySQL Query Browser. Knowing the format for the dropdown list, I was able to format my data correctly and simply copy-paste into the field directly (via MySQL Query Browser). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82MDQ3Ny1jdXN0b20tZmllbGQtYW5kLXRydW5jYXRpb24taXNzdWU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.250 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)