On 7/20/07, André Knappstein, Controlling <[EMAIL PROTECTED]> wrote: > 1.) > update > rdb$database > set > rdb$character_set_name = "WIN1252";
This isn't required. This is default charset for new columns if it's not specified. > 2.) > update > rdb$Fields > set > rdb$character_set_ID = 53 > where > rdb$character_set_ID = 21; > > 3.) > update > rdb$function_arguments > set > rdb$character_set_ID = 53 > where > rdb$character_set_ID = 21; This the quick&dirty version. But if no error is reported during backup&restore, it's fine. > > Then backing up, and restoring into a new database. > Quite brutal, I know, but that worked perfectly. > > But - before I try that with the production databases - did I miss > something important which might beat me only much later?? > > Is there maybe a much more simple way to switch character set for a > database? Changing domain. > Thanks, > André > > > ~~~Ihre Nachricht~~~ > > >> One questions remains, though. > >> If ISO8859_1 is not suitable for that purpose, why have I never been > >> noticing this before? I mean, why do the other drivers/providers > >> translate those bytes correctly to a Euro sign? > > DH> ISO 8859-1 and WIN-1252 are almost exactly the same, except that where ISO > DH> 8859-1 has some control codes, WIN-1252 has a few extra letters (like > U+2020 > DH> †, etc) -- one of those extra letters is the Euro sign. > > DH> Many applications, however (especially Windows applications) treat ISO > DH> 8859-1 as being synonymous with WIN-1252, so that's probably why it worked > DH> in those other cases. .NET is not so lenient, however, and something > marked > DH> as ISO 8859-1 to .NET will not be able to contain a Euro symbol. > > DH> Dean. > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
