field lengths differ across many tables

[steros]

Preconditions

1. any Magento 2 version
2. have no telephone validation except than it's required

Steps to reproduce

1. place an order
2. enter a very wide telephone number (+20 characters)
3. order

Expected result

1. the very long telephone number should appear in the database as the field is 255 characters long in sales_order_address

Actual result

1. the telephone number gets cut off after 20 characters as the quote_order_address field is just set to 20 characters VARCHAR

Fix

See #10868
Raise the characters in quote_order_address to 255 VARCHAR as in sales_order_address

Further comment

I found numerous field lengths to be different across many tables. Thus strings get cut off.
In my case the "telephone" was cut off as someone set it to be just 20 characters in the quote_address table despite it being 255 characters wide in the sales_order_address table.
There are many other fields differing.

Someone seriously needs to check this! Unfortunately I do not have enough knowledge about all the fields.

In my case our customers want to enter not one phone number but sometimes their landline and mobile phone number into the telephone field. The field is not validated against any format.

It seems this is across any version.

[southerncomputer]

Well you should have consistent field sizes - so reducing a 255 -> 20 is a no-go for backwards compatibility, why not propose a patch to fix what you've seen! I've had to manually address this as our ERP uses sql-server which is very unkind and does the right thing -faults the insert on size/truncation where-as mysql does the unthinkable and loses data quite happily!

[steros]

Hey,

I've already proposed a patch and there discussion has gone a bit further.
It seems this is actually a bug which needs to be addressed.

So I'm closing this.

[orlangur]

Here is what needs to be done: #10868 (comment)

Similar issue existed for multiple fields, first/middle/lastname were fixed before but telephone (AND MAYBE other fields, this needs to be checked) are still affected.

[magento-engcom-team]

@steros, thank you for your report.
We've created internal ticket(s) MAGETWO-80421 to track progress on the issue.