Mega Search
23.2 Million


Sign Up

Make a donation  
Field.Datasize vs VARCHAR as created in SQL  
News Group: embarcadero.public.delphi.database.firedac

FDTable1.Fields[0].Datasize := 6 for a VARCHAR field created via an SQL statement as having a size of 5.  This is using FireDAC with SQLite.  Why the difference in size between what I know I created using SQL and what Fields.Datasize returns?  Thanks!

Vote for best question.
Score: 0  # Vote:  0
Date Posted: 20-Jan-2015, at 10:01 AM EST
From: Larry X
 
Re: Field.Datasize vs VARCHAR as created in SQL  
News Group: embarcadero.public.delphi.database.firedac
http://docwiki.embarcadero.com/Libraries/XE7/en/Data.DB.TField.DataSize

This is not how the field is defined, but how much bytes is required to store it value on the client side.

-- 
With best regards,
Dmitry Arefiev / FireDAC Architect

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 20-Jan-2015, at 9:02 PM EST
From: Dmitry Arefiev