Subject Re: [ib-support] Interbase 6.0 : Strange error with french character set...
Author Helen Borrie
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>


All for Open and Open for All
InterBase Developer Initiative ·