Skip to content
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

add support for data type TINYINT (byte) Number of 0..255 [CORE5532] #5800

Open
firebird-automations opened this issue May 5, 2017 · 2 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Roberto Carlos da Silva (robertosistemas)

Please add support for data type TINYINT (byte) Number of 0..255,
This would greatly facilitate the system migration developed for sql server, oracle or mysql.

reference:

https://dev.mysql.com/doc/refman/5.7/en/integer-types.html
https://msdn.microsoft.com/pt-br/library/ms187745.aspx

Thank you

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

You can define your own TINYINT domain which would map to FB SmallInt.

So, there is no real impediment to migration from those other engines/platforms.

@firebird-automations
Copy link
Collaborator Author

Commented by: Roberto Carlos da Silva (robertosistemas)

It is not as simple as this, since the access components would also have to support the TINYINT type.
I'm having trouble migrating a system that is based on the framework: https://www.aspnetboilerplate.com/
Which used data types (enum byte) that is mapped to TINYINT in mysql, sql server and oracle.
In these database managers it works like a charm!
The Solution is not only to create a DOMAIN, but to implement the correct type in the system manager Firebird and also to make the correct implementation in the access components.
I remember that the Firebird .NET driver did a GUID mapping using a tag in the comments field.
I even opened a call regarding this problem in the .NET access drive
Look:
DNET750

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