# Data too long for column 'bank' at row 1

**URL:** <https://www.dolibarr.org/forum/t/data-too-long-for-column-bank-at-row-1/19857>\
**Category:** CRM/SRM Modules\
**Created:** [December 1, 2020, 10:12am UTC](https://www.dolibarr.org/forum/t/data-too-long-for-column-bank-at-row-1/19857 "2020-12-01T10:12:37Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![lam0nade](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/l/ce7236/32.png) [@lam0nade](https://www.dolibarr.org/forum/u/lam0nade)\
**Post date:** [December 1, 2020, 10:12am UTC](https://www.dolibarr.org/forum/t/data-too-long-for-column-bank-at-row-1/19857/1 "2020-12-01T10:12:37Z")

</div>

Hi all.  
I’m new in using Dolibarr. Have `st time istalled Dolibarr: 13.0.0-beta.  
I wanto write dowm Bank name in bank in Edit account, but have problem:  
**Requested URL:** /compta/bank/card.php?id=1  
**Menu manager:** eldy\_menu.php  
**Modules/Applications:** user, societe, propal, fournisseur, supplier\_proposal, banque  
**Database type manager:** mysqli  
**Return code for latest database access request error:** DB\_ERROR\_1406  
**Information for latest database access request error:** Data too long for column ‘bank’ at row 1  
How to FIX?  
I don’t want to allow whole base use longer name, just for this column.

---

<div class="post-metadata">

**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\
**Post date:** [December 1, 2020, 10:15am UTC](https://www.dolibarr.org/forum/t/data-too-long-for-column-bank-at-row-1/19857/2 "2020-12-01T10:15:10Z")

</div>

Hi,

Beta versions are not supported on the forum, only the stable versions.

You should install V12.0.3

---

<div class="post-metadata">

**Author:** ![lam0nade](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/l/ce7236/32.png) [@lam0nade](https://www.dolibarr.org/forum/u/lam0nade)\
**Post date:** [December 1, 2020, 10:41am UTC](https://www.dolibarr.org/forum/t/data-too-long-for-column-bank-at-row-1/19857/4 "2020-12-01T10:41:16Z")

</div>

Have tried on test version 12.0.3. Have same problem.  
I think need to make long name int his column…but i have not fixed it yet.  
Data too long for column ‘bank’ at row 1 sql=INSERT INTO llx\_bank\_account

---

<div class="post-metadata">

**Author:** ![lam0nade](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/l/ce7236/32.png) [@lam0nade](https://www.dolibarr.org/forum/u/lam0nade)\
**Post date:** [December 1, 2020, 12:07pm UTC](https://www.dolibarr.org/forum/t/data-too-long-for-column-bank-at-row-1/19857/5 "2020-12-01T12:07:13Z")

</div>

I have manually changed VARCHAR to 100 by mySQL:

ALTER TABLE «llx\_bank\_account» CHANGE «bank» «bank» VARCHAR(100) CHARACTER SET utf8 COLLATE utf8\_general\_ci NULL DEFAULT NULL;

Need to change " to `

Don’t know where is installation file to change it.

---

<div class="post-metadata">

**Author:** ![planpc](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/planpc/32/303_2.png) [@planpc](https://www.dolibarr.org/forum/u/planpc)\
**Post date:** [September 23, 2021, 7:11am UTC](https://www.dolibarr.org/forum/t/data-too-long-for-column-bank-at-row-1/19857/6 "2021-09-23T07:11:02Z")

</div>

Dolibarr 13.0.4

Error “Data too long for column ‘rum’ at row 1” when trying to add a new bank account for supplier.

I see the “rum” field in “llx\_societe\_rib” is set to 32 characters.

Is it possible that it is too small or does it need to be of this length, if so, why does Dolibarr try to create a more than 32 characters longer length RUM and cause the error?

Anyone else please?

Regards
