Subject | Does Firebird ignore String trailing spaces? |
---|---|
Author | DataCom - Diego |
Post date | 2004-04-20T20:43:54Z |
Hi all,
I noticed that Firebird and InterBase ignore trailing spaces when comparing
two Strings. In a Borland site, I found the following: "SQL requires that
trailing spaces be ignored when comparing two strings of different lengths".
And now I discovered that Oracle doesnt ignore them. Wich one is right?
Thanks in advance,
DIEGO Moreira da Rosa
DataCom Telemática
Av França, 735 - Porto Alegre, RS - 90230-220
Fone: 51 3358 0112
Fax: 51 3358 0101
www.datacom-telematica.com.br
I noticed that Firebird and InterBase ignore trailing spaces when comparing
two Strings. In a Borland site, I found the following: "SQL requires that
trailing spaces be ignored when comparing two strings of different lengths".
And now I discovered that Oracle doesnt ignore them. Wich one is right?
Thanks in advance,
DIEGO Moreira da Rosa
DataCom Telemática
Av França, 735 - Porto Alegre, RS - 90230-220
Fone: 51 3358 0112
Fax: 51 3358 0101
www.datacom-telematica.com.br