Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: SQLite FireDAC trailing spaces



Permlink Replies: 1 - Last Post: Feb 28, 2018 4:01 AM Last Post By: Robert Triest
sarah john

Posts: 6
Registered: 12/24/17
SQLite FireDAC trailing spaces
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 28, 2018 3:49 AM
Hello All,

I'm using Delphi XE7 with FireDAC(https://forums.embarcadero.com) to access SQLite.

When I put data into a TEXT field, any trailing spaces or #0 characters get truncated.

Is there something I can change in either SQLite for Cognos(https://mindmajix.com/cognos-training) or FireDAC to have it preserve the trailing white space?

// The trailing spaces after Command don't come back from SQLite.
fFireDACQuery.ParamByName(kSQLFieldScriptCommands).AsString := 'Command ';

Help me out!

Thanks

Edited by: sarah john on Feb 28, 2018 3:49 AM
Robert Triest

Posts: 687
Registered: 3/24/05
Re: SQLite FireDAC trailing spaces
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 28, 2018 4:01 AM   in response to: sarah john in response to: sarah john
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02