NHibernate: Reading mysql Blob field - value returned as "System.Byte[]"

Question

I have a class with a property:

virtual public string Data { get; set; }

example.hbm.xml binds that to:

<property name="Data" type="string" column="data" ></property>

The table in MySql is created with:

CREATE TABLE `xxx` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `data` blob,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;

I can successfully write to the db and I can see the text in the column written properly.

When I try to read records from this table the value of the 'Data' property is 'System.Byte[]'. Again this is the value of this property. It's type is 'System.String'.

What to do? Thanks in advance for any clues.

I tried charset=UTF8 too.

I also tried type="StringClob" in the mapping file.

Thanks Tymek

Cole W · Accepted Answer · 2011-04-27 12:13:07Z

3

You probably need to read and write this as a byte[]. So you're property definition would look like this instead:

public virtual byte[] Data { get; set; }

In addition to this change you will need to change the type in your mapping. I'm not sure what the type. I think it may be blob.

You can easily convert this data to a string if you need to.

edited Apr 27, 2011 at 12:13

answered Apr 27, 2011 at 12:00

Cole W

15.4k7 gold badges56 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Diego Mijelshon · Accepted Answer · 2011-04-27 12:53:01Z

1

I'm no MySQL expert, but you probably want the column type to be text instead of blob.

With that, type="StringClob" should work

answered Apr 27, 2011 at 12:53

Diego Mijelshon

52.7k16 gold badges119 silver badges159 bronze badges

2 Comments

tmaj Over a year ago

You are totally right, but as the db schema is already in place I'll mark "read it as byte[]" as the best answer.

Diego Mijelshon Over a year ago

@Tymek: that's fine. Keep in mind you'll have to use an Encoding if you want to read it as text.

Collectives™ on Stack Overflow

NHibernate: Reading mysql Blob field - value returned as "System.Byte[]"

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related