You smelled right. ;)
I really want to avoid creating a new db and pumping data.

If I do the bulk update, backup, restore and don't get any errors, I
should be ok, right?

On Nov 19, 2007 7:27 PM, Alexandre Benson Smith
<iblist@...> wrote:

> Erick Sasse wrote:
> > If I want to change the collate for all my varchar fields, is it safe
> > to just do a bulk update on system tables?
> >
> > Thanks.
> >
> >
>
> I am smelling that you are trying to change it to collate PT_BR ;-)
>
> When I need to do this.. I did the following:
>
> 1.) Extract metadata
> 2.) change all domains to use collate XYZ
> 3.) create an empty database with the modified collations
> 4.) pump the data over.
>
> Of course it's not the quickest way of doing, but I am sure it's the
> safest :-)
>
> see you !
>
> --
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>

--
Erick Sasse