From: Julien F. <jul...@gm...> - 2008-09-26 14:06:54
|
Hello, I've got a strange behavior with the provider. The trailing space of a string are trimmed. Let me give you an sample : CREATE TABLE "Item" ( OID INTEGER NOT NULL, "Code" VARCHAR(100) CHARACTER SET UNICODE_FSS, "OptimisticLockField" INTEGER, "GCRecord" INTEGER, /* Keys */ CONSTRAINT "PK_Item" PRIMARY KEY (OID) ); private static string InsertWithFirebirdProvider() { // insert a record with a trailing space using (FbConnection connection = CreateAndOpenConnection()) using (FbCommand command = new FbCommand(GetQueryInsert(), connection)) command.ExecuteNonQuery(); // read the inserted record // the trailing space is trimmed !!! using (FbConnection connection = CreateAndOpenConnection()) using (FbCommand command = new FbCommand(GetQueryRead(), connection)) { object firebirdCode = command.ExecuteScalar(); if (firebirdCode != null) return (string)firebirdCode; else return String.Empty; } } private static string GetQueryInsert() { StringBuilder query = new StringBuilder(); query.AppendLine("insert into \"Item\" (\"OID\", \"Code\", \"OptimisticLockField\", \"GCRecord\")"); query.AppendLine("values (GEN_ID(\"sq_Item\", 1), 'AAA ', 0, null)"); return query.ToString(); } private static string GetQueryRead() { StringBuilder query = new StringBuilder(); query.AppendLine("select \"Code\""); query.AppendLine("from \"Item\""); query.AppendLine("where \"OID\" = (select max(\"OID\") from \"Item\")"); return query.ToString(); } private void button1_Click(object sender, RoutedEventArgs e) { string firebirdCode = InsertWithFirebirdProvider(); StringBuilder message = new StringBuilder(); if (firebirdCode == "AAA ") message.AppendLine("The code is correct"); else if (firebirdCode == "AAA") message.AppendLine("The written code was <AAA >. It's now <AAA>. The trailing space is missing !"); else message.AppendFormat("The written code was <AAA >. It's now <{0}> !{1}", firebirdCode, Environment.NewLine); MessageBox.Show(message.ToString()); } As you can see, I insert a record with a value containing a space as the last character. I can see in the database that it was inserted correctly with the trailing space. The ExecuteScalar() method returns the Code field without the trailing space. Did I do something wrong ? TIA Julien Julien Ferraro - WilLow jul...@wi... - 0692 28 85 43 - Fax : 0262 24 98 85 |
From: Jiri C. <di...@ci...> - 2008-09-27 09:36:46
|
It's trimmed in XdrStream. I've found it few months ago, when fixing another problem. But I don't know, why it's trimmed there. Maybe Carlos knows details. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com |
From: Julien F. <jul...@gm...> - 2008-10-03 06:32:54
|
Hi Jiri, Do you know how I can work around this ? TIA Julien -----Message d'origine----- De : Jiri Cincura [mailto:di...@ci...] Envoyé : samedi 27 septembre 2008 13:30 À : For users and developers of the Firebird .NET providers Objet : Re: [Firebird-net-provider] Trailing spaces trimmed It's trimmed in XdrStream. I've found it few months ago, when fixing another problem. But I don't know, why it's trimmed there. Maybe Carlos knows details. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Jiri C. <di...@ci...> - 2008-10-04 17:15:34
|
On Fri, Oct 3, 2008 at 8:32 AM, Julien Ferraro <jul...@gm...> wrote: > Do you know how I can work around this ? Hardly. I can send you private build with this removed. You can test it and see, whether it works. PS: Carlos, if you're reading, can you see why is this there? -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com |
From: Jiri C. <di...@ci...> - 2008-10-04 17:21:29
|
On Sat, Oct 4, 2008 at 7:15 PM, Jiri Cincura <di...@ci...> wrote: > PS: Carlos, if you're reading, can you see why is this there? Not 'see' but 'say' of course. :) -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com |
From: Julien F. <jul...@gm...> - 2008-09-27 12:49:55
|
So if I understand, it is a known bug ? Is there a workaround ? TIA Julien -----Message d'origine----- De : Jiri Cincura [mailto:di...@ci...] Envoyé : samedi 27 septembre 2008 13:30 À : For users and developers of the Firebird .NET providers Objet : Re: [Firebird-net-provider] Trailing spaces trimmed It's trimmed in XdrStream. I've found it few months ago, when fixing another problem. But I don't know, why it's trimmed there. Maybe Carlos knows details. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Jiri C. <di...@ci...> - 2008-09-27 16:10:35
|
On Sat, Sep 27, 2008 at 2:49 PM, Julien Ferraro <jul...@gm...> wrote: > So if I understand, it is a known bug ? I don't think it's a bug. Maybe it has some reason, because Carlos must be mad to do this without reason. This is also reason, why I didn't removed it. > Is there a workaround ? You can comment the line out. But maybe it introduces problems in protocol. :) -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com |
From: Teträm C. <de...@te...> - 2008-09-27 10:25:59
|
I'm not sure, because of UNICODE charset, it should be (it's out of my knowledge) but AFAIK, varchar fields never kept trailing spaces Thierry Julien Ferraro a écrit : > > Hello, > > I’ve got a strange behavior with the provider. The trailing space of a > string are trimmed. > > Let me give you an sample : > > CREATE TABLE "Item" ( > > OID INTEGER NOT NULL, > > "Code" VARCHAR(100) CHARACTER SET UNICODE_FSS, > > "OptimisticLockField" INTEGER, > > "GCRecord" INTEGER, > > /* Keys */ > > CONSTRAINT "PK_Item" > > PRIMARY KEY (OID) > > ); > > private static string InsertWithFirebirdProvider() > > { > > // insert a record with a trailing space > > using (FbConnection connection = CreateAndOpenConnection()) > > using (FbCommand command = new FbCommand(GetQueryInsert(), connection)) > > command.ExecuteNonQuery(); > > // read the inserted record > > // the trailing space is trimmed !!! > > using (FbConnection connection = CreateAndOpenConnection()) > > using (FbCommand command = new FbCommand(GetQueryRead(), connection)) > > { > > object firebirdCode = command.ExecuteScalar(); > > if (firebirdCode != null) > > return (string)firebirdCode; > > else > > return String.Empty; > > } > > } > > private static string GetQueryInsert() > > { > > StringBuilder query = new StringBuilder(); > > query.AppendLine("insert into \"Item\" (\"OID\", \"Code\", > \"OptimisticLockField\", \"GCRecord\")"); > > query.AppendLine("values (GEN_ID(\"sq_Item\", 1), 'AAA ', 0, null)"); > > return query.ToString(); > > } > > private static string GetQueryRead() > > { > > StringBuilder query = new StringBuilder(); > > query.AppendLine("select \"Code\""); > > query.AppendLine("from \"Item\""); > > query.AppendLine("where \"OID\" = (select max(\"OID\") from \"Item\")"); > > return query.ToString(); > > } > > private void button1_Click(object sender, RoutedEventArgs e) > > { > > string firebirdCode = InsertWithFirebirdProvider(); > > StringBuilder message = new StringBuilder(); > > if (firebirdCode == "AAA ") > > message.AppendLine("The code is correct"); > > else if (firebirdCode == "AAA") > > message.AppendLine("The written code was <AAA >. It's now <AAA>. The > trailing space is missing !"); > > else > > message.AppendFormat("The written code was <AAA >. It's now <{0}> > !{1}", firebirdCode, Environment.NewLine); > > MessageBox.Show(message.ToString()); > > } > > As you can see, I insert a record with a value containing a space as > the last character. I can see in the database that it was inserted > correctly with the trailing space. > > The ExecuteScalar() method returns the Code field without the trailing > space. Did I do something wrong ? > > TIA > > Julien > > Julien Ferraro - WilLow > > jul...@wi... - 0692 28 85 43 - Fax : 0262 24 98 85 > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > ------------------------------------------------------------------------ > > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
From: Julien F. <jul...@gm...> - 2008-10-05 03:29:46
|
Of course, I can test it and see if my tests go green. But I won't be able to find other error that this can lead to. Anyway, if you use a tool like isql, the trailing spaces are not trimmed so I don't see what could be the problem with this -----Message d'origine----- De : Jiri Cincura [mailto:di...@ci...] Envoyé : samedi 4 octobre 2008 21:15 À : For users and developers of the Firebird .NET providers Objet : Re: [Firebird-net-provider] Trailing spaces trimmed On Fri, Oct 3, 2008 at 8:32 AM, Julien Ferraro <jul...@gm...> wrote: > Do you know how I can work around this ? Hardly. I can send you private build with this removed. You can test it and see, whether it works. PS: Carlos, if you're reading, can you see why is this there? -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Jiri C. <di...@ci...> - 2008-10-05 10:42:48
|
On Sun, Oct 5, 2008 at 5:26 AM, Julien Ferraro <jul...@gm...> wrote: > Anyway, if you use a tool like isql, the trailing spaces are not trimmed so > I don't see what could be the problem with this I know. But maybe there's some protocol hack in provider. Anyway, I'm using it for one of my app. without this, so far without problems (but it's doing only few commands). Or maybe it's a "fix" for right trailing spaces in varchar, as above somebody pointed. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com |
From: Carlos G. Á. <car...@gm...> - 2008-10-05 09:06:39
|
Hello: > Hardly. I can send you private build with this removed. You can test > it and see, whether it works. > > PS: Carlos, if you're reading, can you see why is this there? > I didn't remember the exact reason for this ( i think it can be related to some change done time ago on a user request bu didn't remember exact details ) |
From: Jiri C. <di...@ci...> - 2008-10-05 09:34:02
|
On Sun, Oct 5, 2008 at 11:03 AM, Carlos Guzmán Álvarez <car...@gm...> wrote: > I didn't remember the exact reason for this ( i think it can be related > to some change done time ago on a user request bu didn't remember exact > details ) Let's see whether it works without trimming. :) -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com |
From: Jiri C. <di...@ci...> - 2008-10-05 09:27:23
|
On Sun, Oct 5, 2008 at 5:26 AM, Julien Ferraro <jul...@gm...> wrote: > Of course, I can test it and see if my tests go green. But I won't be able > to find other error that this can lead to. Julien, check <http://cid-bdb67deba4c656e5.skydrive.live.com/self.aspx/Ve%c5%99ejn%c3%a9/FirebirdClient|_TrimmedVarchar/FirebirdSql.Data.FirebirdClient.dll>. If it will work, create tracker item. Thanks. If anybody is interested please test it too. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com |
From: Steve F. <ste...@ya...> - 2008-10-05 10:45:24
|
Is something wrong with the list? It is repeating the same emails two, three or more times. Steve |
From: Helen B. <he...@tp...> - 2008-10-05 11:18:03
|
At 20:34 5/10/2008, Steve Faleiro wrote: >Is something wrong with the list? It is repeating the same emails two, >three or more times. Over the past week or so, Sourceforge has been moving all its servers to a new facility in Chicago. Mail has been banking up for all of our SF-based lists. It looks as though some people tried posting the same messages multiple times. This morning I received more than 100 firebird-checkins notifications...grrrrrr....they probably need a better database server, LOL! Helen (Moderator) |
From: Jiri C. <di...@ci...> - 2008-10-10 07:45:27
|
Hello, I've created issue in tracker. http://tracker.firebirdsql.org/browse/DNET-183 . Feel free to put your experience in comment or in list. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com |
From: Jiri C. <di...@ci...> - 2008-10-24 19:42:06
|
Hello, did you experienced any problems? -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com |