Subject | Problems with spanish chars, again |
---|---|
Author | William Gonzáles S. |
Post date | 2006-02-10T14:51:29Z |
Hello all.
The next SQL query:
select * from MACHINES
where (DESCRIPTION like '%matríz%')
or
select * from MACHINES
where (UPPER(DESCRIPTION) like '%MATRÍZ%')
does not give me any records, and there are many with
this condition in MACHINES table.
Mi database and DESCRIPTION field, have UNICODE_FSS
charset and I am using FB 1.5.3
What could be the problem?
Thanks in advance,
William GS
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
The next SQL query:
select * from MACHINES
where (DESCRIPTION like '%matríz%')
or
select * from MACHINES
where (UPPER(DESCRIPTION) like '%MATRÍZ%')
does not give me any records, and there are many with
this condition in MACHINES table.
Mi database and DESCRIPTION field, have UNICODE_FSS
charset and I am using FB 1.5.3
What could be the problem?
Thanks in advance,
William GS
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com