Re: [sqlite] Problem with WHEN expressions inside CASE statement in SELECT statement

Kurt Welgehausen <[EMAIL PROTECTED]> wrote: > Robert Duff <[EMAIL PROTECTED]> wrote: > > > I had a problem with inserting bad unicode characters into my database. > > ... > > Returned by "SELECT locationsFK,variable,logindex, CASE units WHEN units > > ISNULL THEN '#!#!#!#!#!#!#!#!#!#!' WHEN

Re: [sqlite] Problem with WHEN expressions inside CASE statement in SELECT statement

Robert Duff <[EMAIL PROTECTED]> wrote: > I had a problem with inserting bad unicode characters into my database. > ... > Returned by "SELECT locationsFK,variable,logindex, CASE units WHEN units > ISNULL THEN '#!#!#!#!#!#!#!#!#!#!' WHEN units = '??F' THEN > '' WHEN units !=

[sqlite] Problem with WHEN expressions inside CASE statement in SELECT statement

I had a problem with inserting bad unicode characters into my database. In the proccess of running an upgrade, I thought I would filter units like '??F' into '°F'. I believe I have the right logic, but the WHEN expressions of my CASE statement never seem to fire, only the ELSE expression.