Hi Thomas

I try the following:
I create a new domain.
CREATE DOMAIN D_NOME_60_PT AS VARCHAR(60) CHARACTER SET WIN1252
COLLATE PXW_INTL850
Then I change one column to this domain.
I change the charactere set in the connection in IBConsole.
When I try perform a select in this column I receive a error.

Then I'm very interested in your help.



--- In ib-support@y..., "Thomas Steinmaurer"
<thomas.steinmaurer@a...> wrote:

> Enio,
>
> 2 years ago, I've done a conversion from character set NONE to
> WIN1252 with PXW_INTL850 without loss of any data. There are some
> direct modifications on System Tables necessary and in a few cases
> there wasn't such a conversion possible, but maybe I can assist you.
>
> If you are interested, please let me know.
>
> Regards,
> Thomas Steinmaurer
> http://www.iblogmanager.com
>
> --- In ib-support@y..., enio_bueno@y... wrote:
> > I have a large database in a library, character set is set to

none.

> > I'm brasilian and I need change it to WIN1252 and use collate
> > PXW_INTL850
> >
> > Are there how do this and preserve the data ?
> > Or will I need create a new gdb with apropriate character set

and

> > import
> > the data?
> >
> > thanks to all
> >
> > Enio Bueno