At 04:25 PM 26-03-01 +0200, you wrote:

>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'

Pretty simple - 'e' is a legal character in a date literal, 'é' is not.

e.g. a date literal can be '25-dec-2000' but it can't be '25-déc-2000'. Nor 'éèà磧¤' either. <g>

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________