Hello, you are already CREATING the database using CS "NONE".
IBExpert is sometimes using nasty tricks :) I am not too much expert in that but I made the following experience: If there is no pressing need to define CS "NONE" as default for the database, then it would be good to define one Charset and to specify the same CS in your connection. Try that and see if it helps. I do have a lot of special characters and have no problems using Win1252 on both sides. -- Mit freundlichen Grüssen, André Knappstein, EDV und Controlling Verwaltungs- und Erlebniszentrum Marina Rünthe beta Eigenheim GmbH Hafenweg 4 59192 Bergkamen-Rünthe Durchwahl: +49 2389 9240 140 ~~~Ihre Nachricht~~~ AGG> my tests: AGG> "NONE", incorrect results AGG> "UTF8", I/O error for file CreateFile (open) "H:\Firebird AGG> Databases\Facturación.fdb" AGG> Error while trying to open file AGG> "UNICODE_FSS", I/O error for file CreateFile (open) "H:\Firebird AGG> Databases\Facturación.fdb" AGG> Error while trying to open file AGG> "ISO8859_1", arithmetic exception, numeric overflow, or string truncation AGG> Cannot transliterate character between character sets AGG> Looking at RDB$RELATIONS structure from IBExpert: AGG> RDB$RELATION_NAME CHAR(31) CHARACTER SET UNICODE_FSS, AGG> 2008/2/19, Carlos <[EMAIL PROTECTED]>: >> Hello: >> >> >> > I'll start with UTF8. If it wouldn't work. I'll select it as raw >> > bytes and 'll look what the database is sending. >> >> Try using ISO8859-1, i think utf8 will not work as the system tables are not >> unicode compliant ( unless this has changed recently ) >> >> >> -- >> Carlos Guzmán Álvarez >> Vigo-Spain >> ------------------------------------------------------------------------- >> This SF.net email is sponsored by: Microsoft >> Defy all challenges. Microsoft(R) Visual Studio 2008. >> 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 >> >> AGG> ------------------------------------------------------------------------- AGG> This SF.net email is sponsored by: Microsoft AGG> Defy all challenges. Microsoft(R) Visual Studio 2008. AGG> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ AGG> _______________________________________________ AGG> Firebird-net-provider mailing list AGG> [email protected] AGG> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. 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
