Trying to create new database "H:\FACTURAC.FDB" and only one table called "Actividades Económicas" with CS "UTF8", "ISO8859_1" or "WIN1252", from ISQL or IBExpert:
create table "Actividades Económicas" (Id bigint); Statement failed, SQLCODE = -607 unsuccessful metadata update -STORE RDB$USER_PRIVILEGES failed defining a table -arithmetic exception, numeric overflow, or string truncation -Cannot transliterate character between character sets -At trigger 'RDB$TRIGGER_9' If I create the database with CS "UNICODE_FSS", I can create the table with no errors, then connect to the database including CS "UNICODE_FSS" in the connection string, but the select from RDB$RELATIONS doesn't return accented vowels. 2008/2/19, André Knappstein, Controlling <[EMAIL PROTECTED]>: > 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. > ------------------------------------------------------------------------- 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
