Hi !


select * from todolist
where td_date containing 'é'

=> 'é' is egal to é (in html code if you don't have it)

Give me :
"Arithmetic exception, numeric overflow, or string truncation
Cannot transliterate character between character sets
Statement: select * from historique
where h_date_realise containing 'é'"

td_date is a time stamp field (same problem with a integer field).

Same problem with éèà磧¤...

I know it is stupid to compare a date or integer with these characters but
with classic charaters it work fine, for example :
select * from todolist
where td_date containing 'e'




Fabrice Vende
fabrice@...

-
SARL I N F O C O B
Developpement, formation, matériel, logiciel
http://www.infocob.com