Обсуждение: Read problem from Bytea column

Hello,
I have postgresql 8.3.9 database. Now I am working on reading file
from bytea data and save to filesystem.
I am using Npgsql.dll on c#.net.

First I have using OpenERP to upload a file to postgres database in
bytea column. The original file size is 104,960 bytes and .doc
extension.
Then I read the bytea data and save it to file system, its size
becomes 141,790 bytes. This file cannot be opened however its
extension is .doc.

What is going on?

My c# code is below:

             NpgsqlCommand cmd = new NpgsqlCommand("SELECT bytea_col
FROM TableTest LIMIT 1", Conn);
             using (FileStream stream = new FileStream("c:\test.doc",
FileMode.Create))
                    {
                        byte[] rawbytes = (byte[])cmd.ExecuteScalar();
                        stream.Write(rawbytes, 0, rawbytes.Length);
                        stream.Close();
                    }

Francisco Figueiredo Jr

Sent from my Android phone.

Em 21/01/2011 13:50, "orgilhp" <orgilhp@gmail.com> escreveu:
>
> Hello,

Hello!

> I have postgresql 8.3.9 database. Now I am working on reading file
> from bytea data and save to filesystem.
> I am using Npgsql.dll on c#.net.
>

Which version of Npgsql are you using?

Your code is ok and should be working. More info can be get from "Working with binary data and bytea datatype" section of npgsql user manual.

Did you try another npgsql version? If it works in another version, please, fill a bug report so we can fix it.

Thanks in advance!

> First I have using OpenERP to upload a file to postgres database in
> bytea column. The original file size is 104,960 bytes and .doc
> extension.
> Then I read the bytea data and save it to file system, its size
> becomes 141,790 bytes. This file cannot be opened however its
> extension is .doc.
>
> What is going on?
>
> My c# code is below:
>
>             NpgsqlCommand cmd = new NpgsqlCommand("SELECT bytea_col
> FROM TableTest LIMIT 1", Conn);
>             using (FileStream stream = new FileStream("c:\test.doc",
> FileMode.Create))
>                    {
>                        byte[] rawbytes = (byte[])cmd.ExecuteScalar();
>                        stream.Write(rawbytes, 0, rawbytes.Length);
>                        stream.Close();
>                    }
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

Thanks for your reply!

>
> Which version of Npgsql are you using?
>

I am using "Npgsql2.0.11-bin-ms.net".

> Did you try another npgsql version? If it works in another version, please,
> fill a bug report so we can fix it.
>

I have not used another version yet!
But I think that 2.0 is the latest and has more capabilites version!
Is this right?