Subject Re: [firebird-support] Re: UNICODE_FSS in select statement - ERROR
Author Helen Borrie
At 11:51 PM 12/03/2009, you wrote:
>you said to use
>update yourtable
>set tempunicode = cast (ExistingColumn as varchar(50) character set
>is the cast mandatory (I thought it was implicit) or is it just because
>you wanted to provide a generic query (usable in most cases) ?

It's needed, in order for the engine to substitute the 3-byte UNICODE_FSS code sequence for the 1-byte Win1251 code sequence for each character...otherwise, that statement would just throw "malformed string" errors.