0- drop index of this field if exists
1- add a new column
alter table tx add newcol varchar(20) character set none;
2- copy the data to it.
update tx set newcol = oldcol;
3- drop old column
alter table tx drop oldcol;
4- recreate oldcol with new char set that you need
alter table tx add oldcol varchar(20) character set none;
5- copy back the data.
update tx set oldcol = newcol;
6- drop the temporary column
alter table tx drop column newcol;
7- recreate index of this field if you need.

Write a script like this and run it. (or write a SP and call )
There is may be other way to do it via playing system tables, but i dont
know how.

I hope help this.

----- Original Message -----
From: Riho-Rene Ellermaa
To: ib-support@yahoogroups.com
Sent: Monday, January 29, 2001 11:54 AM
Subject: [ib-support] Changing charset in domains


Hi!

I have domain varchar(20) which is used in couple of tables.
I want to change it's charset from none to win1252. How can I do it without
dropping any tables. I must do it in my customers database, so I would
prefer to autorun some script inside my program.

Riho-Rene Ellermaa
senior programmer
Hansabank

Yahoo! Groups Sponsor

www. .com




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com