Text cast problem

Dear all-

I encountered the following problem:

select * from parcel where number = '255 '

gives me 1 row but

select * from parcel where number = '255 ' ::text

does give me 0 rows. The cast removes the trailing empty character.

Why is that? Unfortunately the statements are generated (NPGSQL) and I can’t change the way they are generated. What can I do? Any suggestions highly welcomed!

Volkmar