Skip to content

Michel catalog numbers should support letters #1277

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
php-coder opened this issue Mar 11, 2020 · 3 comments
Closed

Michel catalog numbers should support letters #1277

php-coder opened this issue Mar 11, 2020 · 3 comments

Comments

@php-coder
Copy link
Owner

Similar to #671 but for Michel catalog. We need to support letters in catalog numbers. For example: Mi#1140-43B Bl#63B

@php-coder php-coder added this to the next milestone Mar 11, 2020
@php-coder php-coder self-assigned this Mar 11, 2020
@php-coder php-coder modified the milestones: next, 0.4.3 Mar 11, 2020
@php-coder
Copy link
Owner Author

I can't add it manually:

mysql> insert into michel_catalog(code) values('1140B');
ERROR 1406 (22001): Data too long for column 'code' at row 1
mysql> desc michel_catalog;
+-------+------------+------+-----+---------+----------------+
| Field | Type       | Null | Key | Default | Extra          |
+-------+------------+------+-----+---------+----------------+
| id    | int(11)    | NO   | PRI | NULL    | auto_increment |
| code  | varchar(4) | NO   | UNI | NULL    |                |
+-------+------------+------+-----+---------+----------------+

@php-coder
Copy link
Owner Author

I can't add it manually:

This is similar to #676 when we increased the length of scott_catalog.code field to 5 characters.

@php-coder
Copy link
Owner Author

We need the same for Yvert: 1100A-1104A

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant