FormatException: Bad UTF-8 encoding 0xad

[lasseschmitt]

Hey,

I have to following table:

CREATE TABLE public.addresses
(
    id integer NOT NULL DEFAULT nextval('addresses_id_seq'::regclass),
    line1 character varying COLLATE pg_catalog."default",
    line2 character varying COLLATE pg_catalog."default",
    street character varying COLLATE pg_catalog."default",
    zip character varying COLLATE pg_catalog."default",
    city character varying COLLATE pg_catalog."default",
    country character varying COLLATE pg_catalog."default",
    latitude numeric,
    longitude numeric,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    CONSTRAINT addresses_pkey PRIMARY KEY (id)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

an insert query would be
'INSERT INTO "addresses" ("latitude", "longitude") VALUES (52.529332, 13.405513)'
and when I try to select something

var all = await connection.query('SELECT * FROM "addresses"');

Im getting the following exception:

PostgreSQLSeverity.error : Connection closed or query cancelled (reason: FormatException: Bad UTF-8 encoding 0xad (at offset 11)).

Any idea?

[itsjoeconway]

The numeric data type isn't currently supported, and so the decoder defaults to trying to interpret it as a String. If you can use double precision or real, those types are supported.

[lasseschmitt]

Thanks for the info!