How to insert Byte[] into the Informix database through the SQL Editor interface

Question

I wonder if there's some way to insert Byte[] in to my database column using the INSERT statement through my SQL Editor.

For example

INSERT INTO Temp (id,name) VALUES(1,'rg_book');

I just wanna to test my data and I don't want to make a user interface (file uploader ,...etc).

How to write this statement?

Brian Knight · Accepted Answer · 2013-01-09 16:57:24Z

2

The CLR Byte array type (Byte[]) maps to a VARBINARY type in Informix DB2. See typing information here.

If your name field is expecting character data, use the VARBINARY function to convert the data into a binary representation of the string. See here.

For example:

INSERT INTO Temp (id, name) VALUES (1, VARBINARY('rg_book'));

answered Jan 9, 2013 at 16:57

Brian Knight

5,04130 silver badges34 bronze badges

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

Comments

Ispirer SQLWays Migrations · Accepted Answer · 2015-01-28 13:06:30Z

1

If I were you I would do the following (if I've understood your question correctly):

Create test console project
Using Foreach or For (on your Byte[] array) compose required Insert's and (for example) add them to some file on a disk.
Run this script in Management Studio to fill in a table.

FileInfo f = new FileInfo(@"d:\Inserts.txt");
Byte[] list = {0, 1, 2};

using (StreamWriter w = f.CreateText())
{
    for (int i = 0; i < list.Length; i++)
    {
        w.WriteLine("INSERT INTO [TEMP] ([id], [Name]) VALUES ({0}, 'rg_book')", list[i]);
    }
}

edited Jan 28, 2015 at 13:06

Ispirer SQLWays Migrations

1,0589 silver badges16 bronze badges

answered Jan 9, 2013 at 16:56

Max

8147 silver badges20 bronze badges

Collectives™ on Stack Overflow

How to insert Byte[] into the Informix database through the SQL Editor interface

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related