storing SMALL large objects to postgres with C# (.NET ODBC layer)

Hello,

I've got a problem inserting binary objects into the postgres database.
I have binary objects (e.g. images or smth else) of any size which I
want to insert into the database. Funny is it works for files larger
than 8000 Bytes. If a file is less than 1000 Bytes I get the following
message:
Error message:
--invalid input syntax for type oid: "\074\077......";

If a file is between 1000 and 8000 Bytes my program just crashes
silently. This is a really strange behaviour since the binary files
vary in sizes (big and small onces). It works with C++ using the
SQLPutData class provided by the ODBC layer. In C# I don't have
anything like that (right?).

So, now the question is: Is that an error in my program, my way of
accessing the database, of creating the insert command, of the C# .NET
code, or the postgreSQL ODBC driver I use? I doubt it is the last one,
since it works with C++. Can anyone help me please??

Technical output (source code, logs, etc):
--------------------------------------------------------------------------

I use:
- WinXP SP2
- VS 2005
- Database version: 8.2.0
- PostgreSQL ANSI Driver Version 8.02.02.00
- I create a ODBC DSN entry
- standard settings
- bytea as LO unchecked
- unchecked LF<conversion

Here is my C# code to write the binary object:

public int InsertBLOB(byte[] blob) {
OdbcDataAdapter adapter = null;
try {
adapter = new OdbcDataAdapter();
adapter.InsertCommand = new OdbcCommand();
adapter.InsertCommand.CommandText = "INSERT INTO
binary_object (object) VALUES (?)";
adapter.InsertCommand.Connection = new
OdbcConnection(this._connection.ConnectionString); // my DSN
connection string

// here the binary parameter is defined
adapter.InsertCommand.Parameters.Add("blob",
OdbcType.VarBinary);
adapter.InsertCommand.Parameters["blob"].Direction =
ParameterDirection.Input;
adapter.InsertCommand.Parameters["blob"].Value = blob;
} catch (Exception e) {
LogError(e);
}

try {
adapter.InsertCommand.Connection.Open();
int rowsAffected =
adapter.InsertCommand.ExecuteNonQuery();
adapter.InsertCommand.Connection.Close();
} catch (Exception e) {
LogError(e);
}
}
Here is my database log from the insert statement from an insert when
the file is larger than 8000 Bytes:
--obviously the LO with the oid 121156 was created successfully
2007-01-11 17:44:35 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 17:44:41 LOG: 00000: statement: set DateStyle to 'ISO'
2007-01-11 17:44:41 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 17:44:41 LOG: 00000: statement: set geqo to 'OFF'
2007-01-11 17:44:41 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 17:44:41 LOG: 00000: statement: set extra_float_digits to 2
2007-01-11 17:44:41 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 17:44:41 LOG: 00000: statement: select oid, typbasetype
from pg_type where typname = 'lo'
2007-01-11 17:44:41 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 17:44:41 LOG: 00000: statement: select pg_client_encoding()
2007-01-11 17:44:41 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 17:44:41 LOG: 00000: statement: BEGIN
2007-01-11 17:44:41 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 17:44:41 LOG: 00000: fastpath function call: "lo_creat"
(OID 957)
2007-01-11 17:44:41 LOCATION: HandleFunctionRequest, fastpath.c:333
2007-01-11 17:44:41 LOG: 00000: fastpath function call: "lo_open" (OID
952)
2007-01-11 17:44:41 LOCATION: HandleFunctionRequest, fastpath.c:333
2007-01-11 17:44:41 LOG: 00000: fastpath function call: "lo_lseek"
(OID 956)
2007-01-11 17:44:41 LOCATION: HandleFunctionRequest, fastpath.c:333
2007-01-11 17:44:41 LOG: 00000: fastpath function call: "lowrite" (OID
955)
2007-01-11 17:44:41 LOCATION: HandleFunctionRequest, fastpath.c:333
2007-01-11 17:44:41 LOG: 00000: fastpath function call: "lo_close"
(OID 953)
2007-01-11 17:44:41 LOCATION: HandleFunctionRequest, fastpath.c:333
2007-01-11 17:44:41 LOG: 00000: statement: COMMIT
2007-01-11 17:44:41 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 17:44:41 LOG: 00000: statement: INSERT INTO binary_object
(object) VALUES ('121156'::lo)
2007-01-11 17:44:41 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 17:44:48 LOG: 00000: statement: set DateStyle to 'ISO'
2007-01-11 17:44:48 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 17:44:48 LOG: 00000: statement: set geqo to 'OFF'
2007-01-11 17:44:48 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 17:44:48 LOG: 00000: statement: set extra_float_digits to 2
2007-01-11 17:44:48 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 17:44:48 LOG: 00000: statement: select oid, typbasetype
from pg_type where typname = 'lo'
2007-01-11 17:44:48 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 17:44:48 LOG: 00000: statement: select pg_client_encoding()
2007-01-11 17:44:48 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 17:44:48 LOG: 00000: statement: set DateStyle to 'ISO'
2007-01-11 17:44:48 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 17:44:48 LOG: 00000: statement: set geqo to 'OFF'
2007-01-11 17:44:48 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 17:44:48 LOG: 00000: statement: set extra_float_digits to 2
2007-01-11 17:44:48 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 17:44:48 LOG: 00000: statement: select oid, typbasetype
from pg_type where typname = 'lo'
2007-01-11 17:44:48 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 17:44:48 LOG: 00000: statement: select pg_client_encoding()
2007-01-11 17:44:48 LOCATION: exec_simple_query, postgres.c:811
..............
This is a database log file when the XML file is small (here a test
with a few "1" values as bytes:
--it seems here to switch to insert a bytea object, which of course
is not the case.

2007-01-11 18:14:17 LOG: 00000: statement: set DateStyle to 'ISO'
2007-01-11 18:14:17 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 18:14:17 LOG: 00000: statement: set geqo to 'OFF'
2007-01-11 18:14:17 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 18:14:17 LOG: 00000: statement: set extra_float_digits to 2
2007-01-11 18:14:17 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 18:14:17 LOG: 00000: statement: select oid, typbasetype
from pg_type where typname = 'lo'
2007-01-11 18:14:17 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 18:14:17 LOG: 00000: statement: select pg_client_encoding()
2007-01-11 18:14:17 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 18:14:17 WARNING: 22P06: nonstandard use of \\ in a string
literal at character 44
2007-01-11 18:14:17 HINT: Use the escape string syntax for
backslashes, e.g., E'\\'.
2007-01-11 18:14:17 LOCATION: check_string_escape_warning, scan.l:932
2007-01-11 18:14:17 LOG: 00000: statement: INSERT INTO binary_object
(object) VALUES
('\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001')
2007-01-11 18:14:17 LOCATION: exec_simple_query, postgres.c:811
2007-01-11 18:14:17 ERROR: 22P02: invalid input syntax for type oid:
"\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001\001\001\001\001\001\001\001\001\001\ 001\001\001\001\001\001\001\001\001\001\001\001\00 1\001\001\001"
2007-01-11 18:14:17 LOCATION: oidin_subr, oid.c:64
2007-01-11 18:14:17 STATEMENT: INSERT INTO binary_object (object)
VALUES
('\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001\\001\\0 01\\001\\001\\001\\001\\001\\001\\001\\001')
My table binary_object looks like this: ......................

CREATE TABLE binary_object
(
id serial NOT NULL,
"object" lo NOT NULL,
CONSTRAINT binary_object_pkey PRIMARY KEY (id)
)
WITHOUT OIDS;
ALTER TABLE binary_object OWNER TO postgresadmin;
GRANT ALL ON TABLE binary_object TO postgresadmin;
GRANT SELECT, UPDATE, INSERT, DELETE ON TABLE binary_object TO machine;

--------------------------------------------------------------------------

Thanks for any answers!!
NM

Jan 11 '07 #1

Subscribe Post Reply

2674

by: WinstonSmith | last post by:

Hello everyone, I got a problem about GC when creating large fields (some MB), set reference to null and call GC.Collect. Not all virtual mem is released. Situation improved in .net 1.1 but not...

.NET Framework

array iteration?

by: CSN | last post by:

Is it possible to iterate over an array in plpgsql? Something like: function insert_stuff (rel_ids int) .... foreach rel_ids as id insert into table (rel_id, val) values (id, 5);

PostgreSQL Database

ERRORs after upgrade from 7.2.1 to 7.4 about nonexisting large objects

by: Dirk Försterling | last post by:

Hi, sorry for reposting, but it seems my message just hit nothing but air. If I posted to the wrong list or did something else wrong with the message, please let me know. I really want to...

PostgreSQL Database

SPI question (or not): trying to read from Large Objects from within a function

by: David Helgason | last post by:

What: I'm having trouble finding out how to find the current PGconn connection inside a C function. Looking through the documentation didn't give this up. Could anyone suggest where to look? I...

PostgreSQL Database

SPI question: trying to read from Large Objects from within a function

by: David Helgason | last post by:

What: I'm having trouble finding out how to find the current PGconn connection inside a C function. Looking through the documentation didn't give this up. Could anyone suggest where to look? ...

PostgreSQL Database

Bytea/Large Objects/external files best practices

by: David Helgason | last post by:

I think those best practices threads are a treat to follow (might even consider archiving some of them in a sort of best-practices faq), so here's one more. In coding an game asset server I want...

PostgreSQL Database

pg_dumpall and large objects

by: zhicheng wang | last post by:

hi, the man page says pg_dump cannot dump "large objects". can some one help me on what does this realy mean? how large is large? if we have some icons can we still use pg_dumpall to backup the...

PostgreSQL Database

Best practice using large objects in foreach

by: Benny | last post by:

I just wanted to throw the discussion out there on what the best practice people feel is for using large objects in a foreach loop. For example if you are reusing an Image object in a loop like...

C# / C Sharp

Question about large objects

by: JoeC | last post by:

I have been writing games and I also read about good programming techniques. I tend to create large objects that do lots of things. A good example I have is a unit object. The object controls...

C / C++

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

storing SMALL large objects to postgres with C# (.NET ODBC layer)

Similar topics