Re: [Firebird-net-provider] how to read a single-byte from databasae

2007-06-23 Thread Carlos Guzmán Álvarez
Hello: > So are you saying I should store this single byte as BLOB in FB2.0 database? Use a smallint field. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take co

Re: [Firebird-net-provider] how to read a single-byte from databasae

2007-06-23 Thread Jiri Cincura
On 6/23/07, Nobuya Higuchi <[EMAIL PROTECTED]> wrote: > Thank you for your help. I'm still wondering why .net provider does not > support direct byte read in FbDataAdapter's Fill method, though. It does, cause' it follows abstract ADO.NET classes. If there's a source with byte, you get it with byt

Re: [Firebird-net-provider] how to read a single-byte from databasae

2007-06-23 Thread Nobuya Higuchi
> BTW in FB default UDF pack is ascii_char and ascii_val function. Why > not to use it for getting values from DB. > > Note.: Depends on your needs and performance issues. Finally, you tell me how, and I thank you profundly. ascii_val sounds promising. I have been using my own UDF and didn't look

Re: [Firebird-net-provider] how to read a single-byte from databasae

2007-06-23 Thread Jiri Cincura
BTW in FB default UDF pack is ascii_char and ascii_val function. Why not to use it for getting values from DB. Note.: Depends on your needs and performance issues. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] how to read a single-byte from databasae

2007-06-23 Thread Jiri Cincura
On 6/23/07, Nobuya Higuchi <[EMAIL PROTECTED]> wrote: > > FW means Framework. > > There are many framework, but here, you seem to mean .NET framework. OK, wer're in net-provider list. I suppose, that's obvious, that I'm talking about .NET FW. > > I'm sorry, but it is. Every piece of code in FW is

Re: [Firebird-net-provider] how to read a single-byte from databasae

2007-06-23 Thread Nobuya Higuchi
> FW means Framework. There are many framework, but here, you seem to mean .NET framework. > I'm sorry, but it is. Every piece of code in FW is written to work > primarily with unicode. The way, that you can use any other character > set is the feature. As for string or text, yes, but that is no

Re: [Firebird-net-provider] how to read a single-byte from databasae

2007-06-23 Thread Jiri Cincura
On 6/23/07, Nobuya Higuchi <[EMAIL PROTECTED]> wrote: > Well, so I have been asking how. Let me put it this way. I have a byte in Use the Encoding class (namespace System.Text). > the database (FB2.0). and we have a Byte type in .NET world. I would like > to use the byte information in .NET as a

Re: [Firebird-net-provider] Installation of ddex

2007-06-23 Thread Rob
Hello, I've made the modification but still the same problem that I can't open the connection dialog from the connectionstring in the property page.The server explorer is working fine for firebird. Any ideas? Best regards, Rob. ""Carlos Guzmán Álvarez"" <[EMAIL PROTECTED]> wrote in message n

Re: [Firebird-net-provider] how to read a single-byte from databasae

2007-06-23 Thread Nobuya Higuchi
> 0xA0 ISN'T valid char because EVERYTHING in FW is unicode. You have to > convert your value to unicode first fo be able to cast it to byte. Well, so I have been asking how. Let me put it this way. I have a byte in the database (FB2.0). and we have a Byte type in .NET world. I would like to us

Re: [Firebird-net-provider] how to read a single-byte from databasae

2007-06-23 Thread Jiri Cincura
On 6/23/07, Nobuya Higuchi <[EMAIL PROTECTED]> wrote: > > > First convert the char(1) in your charset into unicode (cause > > everything in FW work with unicode), then use simple conversion: > > char c = 'a'; > > byte b = (byte)c; > > You can do > char c = 'a' > because 'a' is a Char. > > You can't

Re: [Firebird-net-provider] Installation of ddex

2007-06-23 Thread Carlos Guzmán Álvarez
Hello: > > type="System.Data.Common.DbProviderConfigurationHandler, System.Data, > Version=2.1.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c" /> This needs to be: - This SF.net email is sponsored by DB2 Ex

Re: [Firebird-net-provider] Help with the installation of the DDEX

2007-06-23 Thread Carlos Guzmán Álvarez
Hello: > type=3D"System.Data.Common.DbProviderConfigurationHandler, System.Data, > Version=3D2.0.1.0, Culture=3Dneutral, PublicKeyToken=3D3750abcc3150b00c" /> This needs to be: - This SF.net email is sponsored by DB2

Re: [Firebird-net-provider] how to read a single-byte from databasae

2007-06-23 Thread Nobuya Higuchi
> First convert the char(1) in your charset into unicode (cause > everything in FW work with unicode), then use simple conversion: > char c = 'a'; > byte b = (byte)c; You can do char c = 'a' because 'a' is a Char. You can't do char c = (byte)'\xA0'; // a byte with the value of hexadecimal A0,

Re: [Firebird-net-provider] how to read a single-byte from databasae

2007-06-23 Thread Jiri Cincura
On 6/23/07, Nobuya Higuchi <[EMAIL PROTECTED]> wrote: > I'm sorry but this is exactly where it started. > > with the single-byte value being '\xA0' > byte.Parse(inputstring) > emits an error saying incorrect input format. If you read the documentation of FW: "Converts the string representation of