[Firebird-odbc-devel] ODBC {fn RTRIM()} problem

[JD M. <JDM...@pr...>]

Hello.  I have what I hope is a simple question.  I cannot get the ODBC
RTRIM function to work in the FireBird ODBC driver (v2.0.0.142).  I am
passing a statement such as:

SELECT field1, {fn RTRIM(field2)}, field3 FROM tablename WHERE
tablename.id =3D 1;

The command executes fine, but in the resulting data field2 still
contains it's trailing spaces.  Using some other functions (such as {fn
UCASE()}) works fine. (Although I've just noticed that {fn LCASE()}
throws an error...)

If I open a native FB application (i.e. IBOConsole) and execute:

SELECT field1, RTRIM(field2), field3 FROM tablename WHERE tablename.id =
=3D
1;

against the same database using the same credentials, it gets trimmed
fine, so I don't think it's an issue with the DB or table.

This isn't a major issue, of course, as it's easy enough to work around
in code, but I'm curious as to why it doesn't work.

Thanks.
=20
--=20
J.D. McGregor
Software Engineer

PROVIDER ADVANTAGE
        Innovative Services for Health Care
Office: 503.601.3800 * Fax:   503.352.0266
Cell:   520.990.4834 * Email: jdmcgregor@Provider-Advantage.com=20
________________________________________________________________________
__
This e-mail is for the designated recipient(s) only and may contain
privileged or confidential information. If you have received it in
error,
please notify the sender immediately and delete the original. Any other
use of this e-mail is prohibited.