Just to confirm a dude...
What would happen if the change is made directly in the original field
through IBExpert (i.e.).
What about from NONE to WIN1252? And from ISO8859_1 to Win1252?

Ramiro

2009/2/2 Helen Borrie <helebor@...>

> At 07:38 PM 2/02/2009, Set wrote:
> >1. Take a backup of your database (nice to have)
> >2. Create a new field with the desired character set and commit
> >3. Copy the contents of the old field to the new field and commit (UPDATE
> MyTable SET NewField = OldField)
>
> 3. update mytable set newfield = cast (oldfield as varchar(x) character set
> utf8)
>
> where 'x' is the same size for both oldfield and newfield
>
> ./heLen
>
>
>

--
Ramiro Barreca
rbarreca@...


[Non-text portions of this message have been removed]