You can subscribe to this list here.
2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(10) |
Nov
(55) |
Dec
(36) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2003 |
Jan
(38) |
Feb
(108) |
Mar
(79) |
Apr
(95) |
May
(64) |
Jun
(130) |
Jul
(146) |
Aug
(121) |
Sep
(96) |
Oct
(149) |
Nov
(161) |
Dec
(113) |
2004 |
Jan
(113) |
Feb
(163) |
Mar
(248) |
Apr
(132) |
May
(157) |
Jun
(160) |
Jul
(236) |
Aug
(284) |
Sep
(293) |
Oct
(277) |
Nov
(257) |
Dec
(356) |
2005 |
Jan
(203) |
Feb
(190) |
Mar
(220) |
Apr
(165) |
May
(124) |
Jun
(160) |
Jul
(190) |
Aug
(142) |
Sep
(152) |
Oct
(189) |
Nov
(187) |
Dec
(159) |
2006 |
Jan
(170) |
Feb
(151) |
Mar
(212) |
Apr
(262) |
May
(226) |
Jun
(196) |
Jul
(223) |
Aug
(165) |
Sep
(163) |
Oct
(348) |
Nov
(225) |
Dec
(141) |
2007 |
Jan
(261) |
Feb
(161) |
Mar
(222) |
Apr
(193) |
May
(121) |
Jun
(157) |
Jul
(151) |
Aug
(159) |
Sep
(61) |
Oct
(123) |
Nov
(172) |
Dec
(96) |
2008 |
Jan
(104) |
Feb
(138) |
Mar
(131) |
Apr
(131) |
May
(74) |
Jun
(107) |
Jul
(89) |
Aug
(89) |
Sep
(172) |
Oct
(158) |
Nov
(119) |
Dec
(86) |
2009 |
Jan
(52) |
Feb
(84) |
Mar
(78) |
Apr
(83) |
May
(54) |
Jun
(79) |
Jul
(60) |
Aug
(62) |
Sep
(50) |
Oct
(147) |
Nov
(50) |
Dec
(70) |
2010 |
Jan
(135) |
Feb
(113) |
Mar
(74) |
Apr
(93) |
May
(35) |
Jun
(71) |
Jul
(33) |
Aug
(110) |
Sep
(47) |
Oct
(18) |
Nov
(61) |
Dec
(34) |
2011 |
Jan
(46) |
Feb
(47) |
Mar
(25) |
Apr
(24) |
May
(21) |
Jun
(22) |
Jul
(20) |
Aug
(51) |
Sep
(31) |
Oct
(42) |
Nov
(22) |
Dec
(22) |
2012 |
Jan
(31) |
Feb
(19) |
Mar
(25) |
Apr
(55) |
May
(16) |
Jun
(28) |
Jul
(33) |
Aug
(25) |
Sep
(32) |
Oct
(25) |
Nov
(52) |
Dec
(35) |
2013 |
Jan
(43) |
Feb
(18) |
Mar
(36) |
Apr
(45) |
May
(22) |
Jun
(13) |
Jul
(31) |
Aug
(24) |
Sep
(19) |
Oct
(59) |
Nov
(47) |
Dec
(25) |
2014 |
Jan
(27) |
Feb
(15) |
Mar
(38) |
Apr
(10) |
May
(15) |
Jun
(36) |
Jul
(24) |
Aug
(28) |
Sep
(16) |
Oct
(6) |
Nov
(44) |
Dec
(40) |
2015 |
Jan
(52) |
Feb
(22) |
Mar
(13) |
Apr
(17) |
May
(22) |
Jun
(36) |
Jul
(18) |
Aug
(41) |
Sep
(71) |
Oct
(60) |
Nov
(49) |
Dec
(43) |
2016 |
Jan
(60) |
Feb
(13) |
Mar
(21) |
Apr
(28) |
May
(23) |
Jun
(39) |
Jul
(17) |
Aug
(37) |
Sep
(33) |
Oct
(15) |
Nov
(22) |
Dec
(20) |
2017 |
Jan
(27) |
Feb
(40) |
Mar
(48) |
Apr
(19) |
May
(29) |
Jun
(2) |
Jul
(19) |
Aug
(36) |
Sep
(18) |
Oct
(10) |
Nov
(11) |
Dec
(5) |
2018 |
Jan
(5) |
Feb
(4) |
Mar
(5) |
Apr
(3) |
May
(4) |
Jun
(17) |
Jul
(7) |
Aug
(7) |
Sep
(12) |
Oct
(8) |
Nov
(2) |
Dec
|
2019 |
Jan
(8) |
Feb
(5) |
Mar
(3) |
Apr
(5) |
May
(3) |
Jun
(2) |
Jul
(8) |
Aug
(7) |
Sep
(3) |
Oct
(12) |
Nov
(7) |
Dec
(1) |
2020 |
Jan
(8) |
Feb
(3) |
Mar
(7) |
Apr
(1) |
May
(2) |
Jun
(1) |
Jul
(3) |
Aug
(25) |
Sep
(5) |
Oct
(3) |
Nov
(7) |
Dec
(16) |
2021 |
Jan
(11) |
Feb
(10) |
Mar
(16) |
Apr
(8) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: olegmad <ol...@ya...> - 2003-11-14 11:39:51
|
> Don't worry, can you try to debug FbCommand.parseParameters() and see > what is the encoding being used for each parameter in the line: > > Encoding encoding = gdsParams.SqlVar[i].Encoding; when i = 0; EncodingName = Unicode (UTF-8); when i = 1; EncodingName = Cyrillic (Windows); |
From: olegmad <ol...@ya...> - 2003-11-14 11:32:09
|
> I have done a change in the GDS implementation for send the subtype for > char and varchar fields in trh blr description, i want to know if withis > the sample works for you before make the commit in the CVS (and i want > to run the nunit test too before commit it :)), can i send to you a > compiled dll ?? if yes, which version of the .net framework are you using ?? Yes! :) i using .net framework 1.1 Thank you! |
From:
<car...@te...> - 2003-11-14 11:17:25
|
Hello: > Trying to find some backing information on the WWW, now I feel > only quarter-informed. But you invited me to comment... > :) >(a) AND (b) => (c) The whole character set issue is void for .NET, >the connection should always be Unicode, the programmer should >always only see the UTF-16 encoded data and all necessary translation >is done by data provider (there may be a backdoor needed for getting the >actual byte sequence from the server, for very special cases). > I'm using GetString and GetBytes methods of the .NET encoding classes for encode/decode data of character set fields. >It follows, that a column charset declaration only affects the possible >character repertoire for this column and sorting behaviour, but is otherwise >unnoticed by the C# program. > Dou you mean that in sample C# program there are no explicit character set definition for the query parameters ?? >It would be most helpful to compare the behaviour of other DBMS's >data provider implementations, notable PostgreSQL. > It's good idea .... (Huuummmmm I have not great knowledge of PostgreSQL but as i know it doesn't allow character sets per field). -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Peter J. <pet...@gm...> - 2003-11-14 10:32:53
|
Hi Carlos, All, > > Please apologize, both for disturbing the thread structure by > > replying to the digest, and for giving my half-informed view. > > You are not disturbing!!, all comments are wellcome :) Trying to find some backing information on the WWW, now I feel only quarter-informed. But you invited me to comment... > For char and varchar fields Firebird sends the field character set in > the sqlsubtype, i have readed this in a message of Nickolay Samofatov in > the Firebird-Java list ( getParameterMetaData - 06/10/2003 13:04), Perhaps, I was wrong and the 'on the wire' data is really traveling with different character sets. But this only leads to a more radical proposal: (a) The connection character set is the character set seen by the user (i.e. the programmer in this case) (b) .NET works internally always in UTF-16 (a) AND (b) => (c) The whole character set issue is void for .NET, the connection should always be Unicode, the programmer should always only see the UTF-16 encoded data and all necessary translation is done by data provider (there may be a backdoor needed for getting the actual byte sequence from the server, for very special cases). It follows, that a column charset declaration only affects the possible character repertoire for this column and sorting behaviour, but is otherwise unnoticed by the C# program. From the question of the original poster and from vague memories of earlier I18n questions on the list, that seems to be the behaviour that is expected. It would be most helpful to compare the behaviour of other DBMS's data provider implementations, notable PostgreSQL. Best Reagrds, Peter Jacobi -- NEU FÜR ALLE - GMX MediaCenter - für Fotos, Musik, Dateien... Fotoalbum, File Sharing, MMS, Multimedia-Gruß, GMX FotoService Jetzt kostenlos anmelden unter http://www.gmx.net +++ GMX - die erste Adresse für Mail, Message, More! +++ |
From:
<car...@te...> - 2003-11-14 10:29:57
|
Hello: > I try execute you code. > Sorry, but it's don't work for me :((( > I can't understand why this happened. I have done a change in the GDS implementation for send the subtype for char and varchar fields in trh blr description, i want to know if withis the sample works for you before make the commit in the CVS (and i want to run the nunit test too before commit it :)), can i send to you a compiled dll ?? if yes, which version of the .net framework are you using ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From:
<car...@te...> - 2003-11-14 09:25:56
|
Hello: > Please apologize, both for disturbing the thread structure by > replying to the digest, and for giving my half-informed view. You are not disturbing!!, all comments are wellcome :) > I'm the I18n guy, but I have near no experience with the .NET data > provider. > So the best I can say, is that this looks conceptually wrong to me. > > By specifiying a connection character set, using other interfaces, you > specify in which character set the data is exchanged with server. From > this point > on, you are shielded from the actual different character sets used in > different > columns. For char and varchar fields Firebird sends the field character set in the sqlsubtype, i have readed this in a message of Nickolay Samofatov in the Firebird-Java list ( getParameterMetaData - 06/10/2003 13:04), and i decided after comment it on the .net provider list to try to implement it, now the .net provider sends the parameter value to the firebird server encoded with this character set (if it's supported by the .net provider if not it will use the character set specified in the connection string). Maybe i'm wrong but i think it needs to work ok :) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Peter J. <pet...@gm...> - 2003-11-14 08:10:40
|
Hi Carlos, All, Please apologize, both for disturbing the thread structure by replying to the digest, and for giving my half-informed view. <car...@te...> wrote: > It's working fine for me, here is my test database: [...] > string connectionString = > @"Database=D:\TEST.GDB;" + > "User=SYSDBA;" + > "Password=masterkey;" + > "Server=localhost;" + > "Port=3050;" + > "Dialect=3;" + > "Charset=UNICODE_FSS;" + > "pooling=false;" + > "Role=;"; [...] > string sql = "insert into \"test\" (\"unicode_fss\", \"win1251\") values > (@unicodeValue, @win1251)"; > FbCommand unicode_insert = new FbCommand(sql, connection, transaction); > unicode_insert.Parameters.Add("@unicodeValue", FbDbType.VarChar).Value = > "áéíóú"; > unicode_insert.Parameters.Add("@win1251", FbDbType.VarChar).Value = > "áéíóú"; > unicode_insert.ExecuteNonQuery(); I'm the I18n guy, but I have near no experience with the .NET data provider. So the best I can say, is that this looks conceptually wrong to me. By specifiying a connection character set, using other interfaces, you specify in which character set the data is exchanged with server. From this point on, you are shielded from the actual different character sets used in different columns. Either I'm confused on this point, or the .NET provider behaviour is strange. Best Regards, Peter Jacobi -- NEU FÜR ALLE - GMX MediaCenter - für Fotos, Musik, Dateien... Fotoalbum, File Sharing, MMS, Multimedia-Gruß, GMX FotoService Jetzt kostenlos anmelden unter http://www.gmx.net +++ GMX - die erste Adresse für Mail, Message, More! +++ |
From:
<car...@te...> - 2003-11-14 07:55:26
|
Hello: > I try execute you code. > Sorry, but it's don't work for me :((( > I can't understand why this happened. Don't worry, can you try to debug FbCommand.parseParameters() and see what is the encoding being used for each parameter in the line: Encoding encoding = gdsParams.SqlVar[i].Encoding; -- Best regards Carlos Guzmán Álvarez Vigo-Spain P.S: I'm using Firebird 1.5 RC 7 for test this. |
From: olegmad <ol...@ya...> - 2003-11-14 06:11:01
|
> It's working fine for me I try execute you code. Sorry, but it's don't work for me :((( I can't understand why this happened. I catch eception in line: unicode_insert.ExecuteNonQuery(); Here my stack: Unhandled Exception: FirebirdSql.Data.Firebird.FbException: arithmetic exception, numeric overflow, or string truncation Cannot transliterate character between character sets ---> FirebirdSql.Data.Firebird.Gds.GdsException: Exception of type FirebirdSql.Data.Firebird.Gds.GdsException was thrown. at FirebirdSql.Data.Firebird.Gds.GdsAttachment.ReadStatusVector() at FirebirdSql.Data.Firebird.Gds.GdsAttachment.ReceiveResponse() at FirebirdSql.Data.Firebird.Gds.GdsStatement.execute(Boolean isSP) at FirebirdSql.Data.Firebird.FbCommand.InternalExecute() at FirebirdSql.Data.Firebird.FbCommand.ExecuteNonQuery() --- End of inner exception stack trace --- at FirebirdSql.Data.Firebird.FbCommand.ExecuteNonQuery() at ConsoleApplication.MainClass.Main(String[] args) in c:\vss\consoleapplication3\class1.cs:line 33 |
From:
<car...@te...> - 2003-11-13 16:00:41
|
Hello: > Exception: > > Cannot transliterate character between character sets It's working fine for me, here is my test database: SET SQL DIALECT 3; SET NAMES UNICODE_FSS; CREATE DATABASE 'LOCALHOST:c:\test.gdb' USER 'SYSDBA' PASSWORD 'masterkey' PAGE_SIZE 4096 DEFAULT CHARACTER SET UNICODE_FSS; CREATE TABLE "test" ( "unicode_fss" VARCHAR(128) CHARACTER SET UNICODE_FSS, "win1251" VARCHAR(128) CHARACTER SET WIN1251 ); And here is my C# code: string connectionString = @"Database=D:\TEST.GDB;" + "User=SYSDBA;" + "Password=masterkey;" + "Server=localhost;" + "Port=3050;" + "Dialect=3;" + "Charset=UNICODE_FSS;" + "pooling=false;" + "Role=;"; FbConnection connection = new FbConnection(connectionString); connection.Open(); FbTransaction transaction = connection.BeginTransaction(); string sql = "insert into \"test\" (\"unicode_fss\", \"win1251\") values (@unicodeValue, @win1251)"; FbCommand unicode_insert = new FbCommand(sql, connection, transaction); unicode_insert.Parameters.Add("@unicodeValue", FbDbType.VarChar).Value = "áéíóú"; unicode_insert.Parameters.Add("@win1251", FbDbType.VarChar).Value = "áéíóú"; unicode_insert.ExecuteNonQuery(); transaction.Commit(); connection.Close(); -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: olegmad <ol...@ya...> - 2003-11-13 14:15:32
|
> Can you try using parametrized querys, please ?? Anything like this : > > string sql = "insert into \"test\" (\"unicode_fss\") values > (@unicodeValue)"; > FbCommand unicode_insert = new FbCommand(sql, connection); > unicode_insert.Parameters.Add("@unicodeValue", FbDbType.VarChar).Value = > "áóíéú"; > unicode_insert.ExecuteNonQuery(); > unicode_insert.Dispose(); > > sql = "insert into \"test\" (\"win1251\") values (@win1251Value)"; > FbCommand win1251_insert = new FbCommand(sql, connection); > win1251_insert.Parameters.Add("@win1251Value", FbDbType.VarChar).Value = > "áóíéú"; > win1251_insert.ExecuteNonQuery(); > win1251_insert.Dispose(); > > > This needs to handle correctly the character set of each field. I try, but when i using parametrized querys - i can't post text data in fields this diffrent charset. My code sample: ------------- class MainClass { static private readonly string ConnectionString = @"Charset=UNICODE_FSS;Server=80.80.104.12;Database=c:\temp\carlos.gdb;Connec tion Lifetime=15;Dialect=3;User=carlos;Password=carlos;"; static void Main(string[] args) { using (FbConnection connection = new FbConnection(ConnectionString)) { connection.Open(); FbTransaction transaction = connection.BeginTransaction(); FbCommand command; command = new FbCommand("insert into \"test\" (\"unicode_fss\") VALUES (@my_param)", connection, transaction); command.Parameters.Add("@my_param", FbDbType.VarChar).Value = "????????"; command.ExecuteNonQuery(); command = new FbCommand("insert into \"test\" (\"win1251\") VALUES (@my_param)", connection, transaction); command.Parameters.Add("@my_param", FbDbType.VarChar).Value = "????????"; command.ExecuteNonQuery(); // Exception HERE !!!! transaction.Commit(); } } } ----------------- Exception: Cannot transliterate character between character sets |
From: olegmad <ol...@ya...> - 2003-11-13 14:06:45
|
> Ok, i'm going to try to review it, just one question are you using beta > 3/4 or a previous one?? i using fb.net provider beta 4 for firebird 1.5 |
From:
<car...@te...> - 2003-11-13 11:01:37
|
Hello: > --- > command = new FbCommand("insert into \"test\" (\"unicode_fss\") VALUES > ('<russian text>')", connection, transaction); // in VALUE i use russian > text > command.ExecuteNonQuery(); > > command = new FbCommand("insert into \"test\" (\"win1251\") VALUES > ('<russian text>')", connection, transaction); // in VALUE i use russian > text > > command.ExecuteNonQuery(); Can you try using parametrized querys, please ?? Anything like this : string sql = "insert into \"test\" (\"unicode_fss\") values (@unicodeValue)"; FbCommand unicode_insert = new FbCommand(sql, connection); unicode_insert.Parameters.Add("@unicodeValue", FbDbType.VarChar).Value = "áóíéú"; unicode_insert.ExecuteNonQuery(); unicode_insert.Dispose(); sql = "insert into \"test\" (\"win1251\") values (@win1251Value)"; FbCommand win1251_insert = new FbCommand(sql, connection); win1251_insert.Parameters.Add("@win1251Value", FbDbType.VarChar).Value = "áóíéú"; win1251_insert.ExecuteNonQuery(); win1251_insert.Dispose(); This needs to handle correctly the character set of each field. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From:
<car...@te...> - 2003-11-13 10:47:28
|
Hello: > So it's still not possible to use Firebird .net provider with the Embbeded > version? Before version 2.0 probably not but this will depend too in the time i get for make the wrapper for the firebird client/embbeded server and when is released .net framework 2.0 ;). -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From:
<car...@te...> - 2003-11-13 10:44:50
|
Hello: > 1 vote more for the embedded database. For people that wants to distribute > the database with their applications is essential the embedded database. > Deployment is much easier!!! Ok, ok ... understood !!! :D -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From:
<car...@te...> - 2003-11-13 09:56:16
|
Hello: > But my fields have diffrent charset. Ok, i'm going to try to review it, just one question are you using beta 3/4 or a previous one?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: olegmad <ol...@ya...> - 2003-11-13 09:38:44
|
Hi, again! Here my new problem :) ------------------ Database charset: UNICODE_FSS I create table: CREATE TABLE "test" ( "unicode_fss" VARCHAR(128) CHARACTER SET UNICODE_FSS, "win1251" VARCHAR(128) CHARACTER SET WIN1251 ); when i use connection string: "charset=UNICODE_FSS; blablabla..." and try run that code: --- command = new FbCommand("insert into \"test\" (\"unicode_fss\") VALUES ('<russian text>')", connection, transaction); // in VALUE i use russian text command.ExecuteNonQuery(); command = new FbCommand("insert into \"test\" (\"win1251\") VALUES ('<russian text>')", connection, transaction); // in VALUE i use russian text command.ExecuteNonQuery(); And now, when i try fetch data: command = new FbCommand("select * from \"test\"", connection, transaction); FbDataAdapter dataAdapter = new FbDataAdapter(command); DataTable table = new DataTable(); dataAdapter.Fill(table); ----------------- I receive two rows: First row contains:. | <russian text> | DbNull | Second row contains: | DbNull | <russian unreadable text> | ------------------ And now, if i change connection string: "charset=WIN1251; blablabla..." and fetch data again: I receive two rows: First row contains: | <russian unreadable text> | DbNull | Second row contains: | DbNull | <russian text> | ------------------- So, when i insert data in database - all conversion realize correcly, but when i select from base - fb.net provider conversion all text data in charset which i type in connection string. But my fields have diffrent charset. Thanks. |
From: Miha M. <miham@NO!SPAM.spin.si> - 2003-11-13 08:24:57
|
Ditto. > 1 vote more for the embedded database. For people that wants to distribute > the database with their applications is essential the embedded database. > Deployment is much easier!!! |
From: Jesus A. <ja...@er...> - 2003-11-13 08:15:54
|
1 vote more for the embedded database. For people that wants to distribute the database with their applications is essential the embedded database. Deployment is much easier!!! Jesus Miha Markic wrote: >Point 2 is very welcome :) > >Miha > >"Carlos Guzmán Álvarez" <car...@te...> wrote in message >news:3FB...@te...... > > >>Hello: >> >>The beta 4 is the last beta release before start the RC stage, i'm >>starting to think in the needs we are going to have after 1.5 release, i >>think we have two mayor needs for the future: >> >> > > > > >------------------------------------------------------- >This SF.Net email sponsored by: ApacheCon 2003, >16-19 November in Las Vegas. Learn firsthand the latest >developments in Apache, PHP, Perl, XML, Java, MySQL, >WebDAV, and more! http://www.apachecon.com/ >_______________________________________________ >Firebird-net-provider mailing list >Fir...@li... >https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > |
From: Miguel M <bo...@ne...> - 2003-11-12 23:56:06
|
So it's still not possible to use Firebird .net provider with the Embbeded version? "Carlos Guzmán Álvarez" <car...@te...> wrote in message news:3FB...@te...... > Hello: > > > Point 2 is very welcome :) > > :) > > > > > -- > Best regards > > Carlos Guzmán Álvarez > Vigo-Spain > > > > ------------------------------------------------------- > This SF.Net email sponsored by: ApacheCon 2003, > 16-19 November in Las Vegas. Learn firsthand the latest > developments in Apache, PHP, Perl, XML, Java, MySQL, > WebDAV, and more! http://www.apachecon.com/ > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
From: olegmad <ol...@ya...> - 2003-11-12 18:14:42
|
> If i'm not wrong IBexpert doesn't handle ok UNICODE_FSS character set, > maybe i'm wrong but i think it has no real support for UNICODE_FSS > character set ;) ( i have problem with it some time ago making tests > with UNICODE_FSS ) You right!!! IB Expert can't changes charset :( Hi used windows default charset when post data in database. Greate thanks! |
From:
<car...@te...> - 2003-11-12 17:13:02
|
Hello: > When i post and retrieve data with fb.net provider - it's ok, BUT I can't > read this text with IB Expert (IB Console and other tools). > May be fb.net > provider > works wrong with charsets? If i'm not wrong IBexpert doesn't handle ok UNICODE_FSS character set, maybe i'm wrong but i think it has no real support for UNICODE_FSS character set ;) ( i have problem with it some time ago making tests with UNICODE_FSS ) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: olegmad <ol...@ya...> - 2003-11-12 16:54:13
|
Hello, Carlos! I use such tools as IB Expert (www.ibexpert.com), IB Console and etc. to input data to database. When i post data (text in russian) to database and try fetch that data with fb.net provider - all russian text disappeares (f.e. for text "bebebe <rusian text> tetete" fb.net provider returns "bebebe tetete"). When i post and retrieve data with fb.net provider - it's ok, BUT I can't read this text with IB Expert (IB Console and other tools). May be fb.net provider works wrong with charsets? ---------------- I create database with charset: UNICODE_FSS ---------------- CREATE TABLE "test" ( "unicode_fss" VARCHAR(128), "description" VARCHAR(128) ); ---------------- using System; using System.Data; using FirebirdSql.Data.Firebird; namespace ConsoleApplication { class MainClass { static private readonly string ConnectionString = @"Charset=UNICODE_FSS;Server=80.80.104.12;Database=c:\temp\carlos.gdb;Connec tion Lifetime=15;Dialect=3;User=carlos;Password=carlos;"; static void Main(string[] args) { using (FbConnection connection = new FbConnection(ConnectionString)) { connection.Open(); FbCommand command = new FbCommand("select * from \"test\"", connection); FbDataAdapter dataAdapter = new FbDataAdapter(command); DataTable table = new DataTable(); dataAdapter.Fill(table); foreach (DataRow dataRow in table.Rows) { Console.WriteLine("Text: {0};\t\tDescription: {1}", dataRow[0], dataRow[1]); } } } } } -------------- I add 3 rows to table: 1. I used ib expert 2. I used fb.net provider 3. I used ib console I used for this command: INSERT INTO "test" ("unicode_fss") VALUES ('!!! <russian text> !!!') |
From: Marketing P. S.A. <jc...@ma...> - 2003-11-12 02:31:55
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4=2E0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Typ= e> <META content=3D"MSHTML 5=2E00=2E3700=2E6699" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <B><FONT color=3D#ff0000>Tener ventas a través de Internet es de vi= tal importancia=20 para sus resultados=2E</FONT></B> <BR> Hay 600 millones de personas conectadas a Internet y el 90% está en= países=20 desarrollados, jóvenes y con alto poder <br> adquisitivo (1)<br> <b>Vende lo suficiente a través de Internet?</b> <br> Su Website debe aparecer en los buscadores, tener información siemp= re actualizada=20 (que Ud=2E mismo pueda cambiar) y <br> que se encuentre en 2 CLICKS=2E<br> <br> Nosotros lo podemos hacer=2E Contáctenos=2E<br> Atentamente<br> <br> Juan Chapar<br> <P><B><U><FONT color=3D#666666>Vea nuestros clientes y servicios en : <A=20= href=3D"http://www=2EMarketingPlus=2Enet">www=2EMarketingPlus=2Enet</A></F= ONT></U></B> <BR> Soluciones Administrativas y de Gesti=F3n en Internet <BR> Estrategia, Desarrollo y Operaci=F3n de Websites <BR> <A=20 href=3D"mailto:jc@marketingplus=2Enet"><B><U><font color=3D"#3333ff">info@= marketingplus=2Enet</font></U></B>=20 </A>Voice/Fax (5411) 4313 2929 <P><font size=3D"2">(1) Fuente; http://cyberatlas=2Einternet=2Ecom/big_pic= ture/geographics/article/0,,5911_3101791,00=2Ehtml</font>=20 <P><font size=3D"2" color=3D"#666666">Si desea ser eliminado de nuestra li= sta envíe=20 un e-mail a <a href=3D"mailto:delete@marketingplus=2Enet">delete@marketi= ngplus=2Enet</a></font> </BODY></HTML> |
From:
<car...@te...> - 2003-11-11 21:22:08
|
Hello: > Point 2 is very welcome :) :) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |