Hi all, Downloaded and installed latest FlameRobin. Created the same database h:\FACTURAC.FDB, CS UNICODE_FSS, and the same table "Actividades Económicas" (id bigint not null primery key). Connection string with CS UNICODE_FSS. Now provider returns accented vowels. Exactly the same process fails using IBExpert.
Still exists the problem with database name and "national characters" in the connection string... Thank you all for your help, 2008/2/19, Aitor Gómez González <[EMAIL PROTECTED]>: > 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
