I’m importing a text file to my database trough Delphi.
In my table there is a field:
DEENDERECO varchar(150)
I use a simple insert SQL to populate the table
insert into table (field1,…, DEENDERECO,…) values (…,’street 50 ‘,…)
Sometimes, this field is showed and printed as "street 50 " instead of "street 50" on my Delphi application.
Using a database viewer (IbExpert), the field is shown as "street 50", with no right blank characters.
When I do a copy/paste in this field and post the change, the problem disappears.
When I update another record, by SQL statement, the problem persists.
View the text file in binary mode, all blank characters are code 0x20.
I'm using both, Delphi 6 and 7, with dbExpIda 2.50.0.23
I have a database and a query sample.
Problem with trailing spaces on varchar field
-
- Posts: 13
- Joined: Fri 03 Sep 2010 14:33
-
- Posts: 13
- Joined: Fri 03 Sep 2010 14:33
-
- Posts: 13
- Joined: Fri 03 Sep 2010 14:33