Trunc last blank

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
Bug_S
Posts: 1
Joined: Fri 26 May 2006 07:07

Trunc last blank

Post by Bug_S » Fri 26 May 2006 07:25

Hello.
I have a varchar column in my table:
table1, column1 (varchar).

When I execute the following sql:
DataSet.Add('Insert into Table1 (Column1) values (:Param1)')

with

Param1 := 'A ';

a new row in Table1 contains 'A' - without last blank ' '

When I make update - all is ok.
Is this a bug?

Jackson
Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Fri 26 May 2006 09:30

We couldn't reproduce the problem.
Please download the last DbxSda version.

If the problem is still present then send us a complete small test project
to reproduce the problem; it is desirable to use Northwind or Master schema
objects, otherwise include definition of your own database objects; don't
use third party components

Also supply us following information
- Exact version of Delphi or C++ Builder
- Exact version of DbxSda. You can see it in ReadMe.html
- Exact version of Microsoft SQL Server and OLE DB provider that you use. You can see it in version info of SQLOLEDB.DLL and SQLNCLI.DLL.

Post Reply