Code: Select all
CREATE OR REPLACE FUNCTION fn_MyProc (cpositions bytea[])
RETURNS void AS
$BODY$
BEGIN
-- nop
END $BODY$
LANGUAGE plpgsql VOLATILE STRICT
COST 100;Exception when the Text contains German Umlauts or any other character with diacritics. I've tried adding a "SET CLIENT_ENCODING TO 'utf8'" (server encoding is utf8) to the command but that did not change anything.invalid byte sequence for encoding 'UTF8'
Code: Select all
object[] array = { "Hello", "World", "böse" };
using (PgSqlConnection con = new PgSqlConnection("aValidConnectionString"))
{
con.Open();
using (PgSqlTransaction tx = con.BeginTransaction())
{
using (PgSqlCommand command = new PgSqlCommand(@"fn_test", con))
{
command.CommandText = @"fn_test";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@cterms", PgSqlType.Array).Value =
new PgSqlArray(array, PgSqlType.Text, 1, array.Length);
command.ExecuteNonQuery();
}
tx.Commit();
}
}
. Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection.
Code: Select all
byte[][] positions = new byte[10][];
// filling positions - 2.Dimension is of variable length
using (PgSqlCommand command = CreateCommand(tx))
{
command.CommandType = CommandType.StoredProcedure;
command.CommandText = @"MyProc";
command.Parameters.Add("@param", PgSqlType.Array).Value = new PgSqlArray(positions, PgSqlType.ByteA, 1, positions.Length);
command.ExecuteNonQuery();
}Exception on ExecuteNonQuery(). I have no problem doing the same with Varchar, Int, BigInt etc. Did i hit a limitation of the Array Type or am i doing something wrong?Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection.