| Subject | Re: [firebird-support] Re: UNICODE_FSS in select statement - ERROR |
|---|---|
| Author | Helen Borrie |
| Post date | 2009-03-12T14:07:45Z |
At 11:51 PM 12/03/2009, you wrote:
./heLen
>Hi,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.
>
>you said to use
>update yourtable
>set tempunicode = cast (ExistingColumn as varchar(50) character set
>UNICODE_FSS)
>
>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) ?
./heLen