Helmar
11-28-2000, 10:07 AM
Interesting difference in the way trailing blanks are handled:
In Oracle 8.0.5, text data is stored in a VarChar2.
In MS SQL Server, text data is stored in a VarChar.
If you store the value "ABC", both return "ABC".
If you store the value "ABC ", MS SQL returns "ABC", BUT
Oracle returns "ABC ".
This can affect your program if you're doing comparisons.
Fix is RTRIM when saving or retrieving the field data.
Helmar B. Herman, VP ProtoProducts
In Oracle 8.0.5, text data is stored in a VarChar2.
In MS SQL Server, text data is stored in a VarChar.
If you store the value "ABC", both return "ABC".
If you store the value "ABC ", MS SQL returns "ABC", BUT
Oracle returns "ABC ".
This can affect your program if you're doing comparisons.
Fix is RTRIM when saving or retrieving the field data.
Helmar B. Herman, VP ProtoProducts