Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SqlServer string data

0 views
Skip to first unread message

David Seay

unread,
May 14, 1997, 3:00:00 AM5/14/97
to

We have an extensive tested app written in Centura Team Developer with
connectivity to SQLBase. We are now testing it against Sql Server and
have found that there is a difference in the string data.

A 4 character field in SqlBase that has 'A' in it has 'A***' where the
'*' indicate spaces. I did an 'UNLOAD DATA SQL' in SQLTALK ( an Centura
'ISQL'-like utility) (a check of the file showed no appended spaces in
the string data) and then loaded and ran the unload file against the Sql
Server database in SQLTALK without error. All the data was transfered.

Where are the padded spaces coming from and how do I either get rid of
them or prevent them in the first place?

--
David Seay, V.P. Research and Development
MortgageFlex Systems, Inc. 904-356-2490 (Voice)
50 N. Laura Street,Suite 2100 904-356-1009 (Fax)
Jacksonville, FL 32202 ds...@mortgageflex.com


Mitchell C. Sharp

unread,
May 17, 1997, 3:00:00 AM5/17/97
to

Define the field as a VarChar and the problem should go away. Not sure how
you are retrieving the data but I assume that you are using ODBC. If not
and you are using the client libraries you can always define the BIND as a
NTBSTRING.

David Seay <ds...@mortgageflex.com> wrote in article
<337A23F0...@mortgageflex.com>...

0 new messages