Subject | Problem with FB 2.0 and '=' operator |
---|---|
Author | William Gonzáles S. |
Post date | 2006-12-02T17:08:27Z |
Hello everybody,
When I execute this query: select * from CONTAINERS
it works fine and gives me:
CONTAINER_ID NAME ACTIVE
1000 Ventas 1
1001 Oficina Técnica 1
But, if I execute this:
select * from CONTAINERS where NAME='Ventas'
It gives and empty recordset, this happen in all SQL
queries with '=' operator.
Db was created with FB 1.5.3, I made a backup and then
I restored it in FB 2.00.
Char Set: ISO8859_1
Collate: PT_BR
¿What could be the problem?
Thanks in advance,
William G.S.
____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com
When I execute this query: select * from CONTAINERS
it works fine and gives me:
CONTAINER_ID NAME ACTIVE
1000 Ventas 1
1001 Oficina Técnica 1
But, if I execute this:
select * from CONTAINERS where NAME='Ventas'
It gives and empty recordset, this happen in all SQL
queries with '=' operator.
Db was created with FB 1.5.3, I made a backup and then
I restored it in FB 2.00.
Char Set: ISO8859_1
Collate: PT_BR
¿What could be the problem?
Thanks in advance,
William G.S.
____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com