| Subject | Re: [firebird-support] What are the trade-offs of CHAR vs. VARCHAR? |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2019-11-14T16:12:33Z |
14.11.2019 17:06, blackfalconsoftware@... [firebird-support] wrote:
how Firebird engine operates.
data. This is the only relevant difference between them. In all other respects they are
the same.
--
WBR, SD.
> What do you mean I am wrong? I have merely re-iterated how all database engines I haveHow "all database engines operate" is irrelevant here. You are wrong in your assumption
> worked operate.
how Firebird engine operates.
> And what you are saying is that a CHAR field in Firebird acts in the same manner as that of a VARCHAR field. If that were the case there would be no difference in how they are used and no reason to have two different data types.I repeat once again: CHAR is for fixed length data, VARCHAR is for variable length
data. This is the only relevant difference between them. In all other respects they are
the same.
--
WBR, SD.