Just for confirmation: I was testing with a backup of several production databases. All results were the same: changing charset from ISO8859_1 to WIN1252 for all objects in the database does the trick.
I can then read and write the Euro-sign not only via ODBC and .net for ODBC and via other drivers, but ALSO via FB.net provider. I have one request for advice from the experts here, please: Not needing the database 24/7, luckily, I was taking it offline and doing the following 3 steps: 1.) update rdb$database set rdb$character_set_name = "WIN1252"; 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; 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? 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 [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
