Subject Re: Query returning incorrect data
Author phil_hhn
--- In, Roman Rokytskyy <roman@...> wrote:
> Either remove the last line or use
> props.put("charSet", "UTF-8");
Ok thanks, will try tomorrow at the office

> >> select (case when status=1 then _UNICODE_FSS 'Yes' else
> >> 'No' end) as FlagStr from mytable
> >
> > Unfortunately that did not work...
> Same result or an error?
Sorry, I meant it did not fix it... got the same result.