Hi guys,

I have a DB column with NONE charset and it contains characters from WIN-1250 charset. Now, I would like to change character set of this column to UTF8.

I've read below topic in order to do this:

http://groups.yahoo.com/neo/groups/firebird-support/conversations/topics/100023

The problem is that update does not work:

Error: *** IBPP::SQLException ***
Context: Statement::Execute( UPDATE
  ATTRIBUTES_VALUES
SET
  ATV_VALUE_UTF8 = CAST(ATV_VALUE AS VARCHAR(255) CHARACTER SET UTF8) )
Message: isc_dsql_execute2 failed

SQL Message : -104
Invalid token

Engine Code    : 335544849
Engine Message :
Malformed string

Does it mean, that I have to convert this column manually? I mean, I need to load all data from old column to my application, convert it outside the firebird and put it back to the new column.

There is no way for Firebird to do this automatically?

Thanks