powered by Jive Software

Changing TinyInt to TinyInt(1) in schema

Hi
i am using openfire 3.6.3. Its not a bug. I just need one confirmation. Is it safe to assume that all TinyInt will be treated as bool so i can change it to TinyInt(1). Because i’m scaffolding the schema using EfCore with https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql it handles TinyInt(1) to bool and TinyInt to byte/sbyte .

Although this probably does not matter: Openfire 3.6.3 is very, very old. Did you mean 4.6.3?

As far as I know, the numeric indicator ‘m’ in TinyInt(m) in MySQL refers to the display width, and has nothing to do with the range of values that can be stored in a column using that data type definition. If I’m right, then handling TinyInt(1) as a boolean is probably a problem, as a lot more than two values can be stored.

yes sorry for typo its 4.6.3. Sorry i misunderstood with range of values it can store.