From: <ch...@co...> - 2004-04-27 21:14:41
|
In the database project that I've previously mention I had to write a persistance layer that wraps the Firebird.NET provider. The reason is that I can write to my persistance layer for both Firebird and possibly SQLServer and other DB's. A situation could arise whereby data could be obtained from disparate databases. The problem is that SQLServer provider supports ConnectionTimeout and the Firebird provider throws an exception. My request is that ConnectionTimeout rather than throw a runtime exeception to return 0 and use an Assert instead. Once again I modified the provider to return 0 causing no behavioral changes to the provider but now my layer can work polymorphically. Thanks, Chris > > The question is how to use a 16-byte GUID in Firebird when the system > > itself doesn't. In the database that I'm designing with Firebird I > > decided to reserve CHAR(16) for GUID only. If I have a need for a > > 16-byte character representation then I'll use either VARCHAR(16) or > > CHAR(17). In the CHAR(17) case I'm anticipating the front end to limit user > > input. > > A column of "char(16) character set octets" should in theory hold > a binary GUID. > > But it is a field of research, whether all layers involved will gladly > handle bytes of zero in this. It's worth a try. > > A middle ground between binary and textual GUIDs would be to use base64 > encoded binary GUIDs, requiring 22 bytes. > > Regards, > Peter Jacobi > > > > ------------------------------------------------------- > This SF.net email is sponsored by: The Robotic Monkeys at ThinkGeek > For a limited time only, get FREE Ground shipping on all orders of $35 > or more. Hurry up and shop folks, this offer expires April 30th! > http://www.thinkgeek.com/freeshipping/?cpg=12297 > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |