| Subject | Re: [firebird-support] What are the trade-offs of CHAR vs. VARCHAR? |
|---|---|
| Author | Clyde Eisenbeis |
| Post date | 2019-11-12T22:06:17Z |
As I understand, the FbConnection.CreateDatabase
max
pageSize for VARCHAR is 8191. Does the page size change to less than 8191 if the VARCHAR is less?
What is the max
pageSize for CHAR?
````````````````
On Tue, Nov 12, 2019 at 1:15 PM Dimitry Sibiryakov sd@... [firebird-support] <firebird-support@yahoogroups.com> wrote:12.11.2019 18:38, cte677@... [firebird-support] wrote:
> I know that VARCHAR consumes less space.
It doesn't. CHAR has no advantages over VARCHAR in most usages. Only very little cases
need fixed length data (and usually it is binary data).
--
WBR, SD.
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-digest@yahoogroups.com
firebird-support-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/