Martijn,


Martijn Tonies wrote:

>
>> Up to now I worked with ISO8859_1 but would like to convert over to use
>> UTF8.
>>
>> What is the most efficient way of changing the database?
>
> Extract DDL, replace default characterset, re-create and datapump.

Thanks for the tip. I only have these two to replace:

SET NAMES ISO8859_1;
DEFAULT CHARACTER SET ISO8859_1;

So, I hoped for something like an "Alter character set", but I guess I
will have to do some coding to do the datadump transparently for the user.

Werner

>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
> MS SQL Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>