invalid byte sequence for encoding \"UTF8\": 0xf9"

[Simone Torri]

Hello,
i'm using dotConnect for PostgreeSQL but when i use this ling query:

var id = (from x in pmr.findAllGroups()
where x.Name.Trim().Equals('Pùblico')
select x.Id).SingleOrDefault();

in PostgreeSQL linq render this query:

SELECT "Extent1"."ID"
FROM public."GRUPOS" AS "Extent1"
WHERE ((Trim("Extent1"."NOMBRE")) = (Trim('Público'))) OR (Trim("Extent1"."NOMBRE") IS NULL AND (Trim('Público') IS NULL))
[public."GRUPOS" varchar(100), public."ID" INTEGER]

and, curious, work without problems in postgreeSQL directly... and offcurse i dont see any error in both if i don't filter for 'Público' but i only filter for Publico' (without using UTF8 coding [ù])

Thanckyou for any help!

[Shalex]

Please add "Unicode=true;" to your connection string and try again.

[Simone Torri]

Thanck's!