utf 8 - Greek charset is causing problems when retriving data though ADO from PostgreSQL -

i having problem charset , colleration of postgresql. when setup new database can choose between c, greek_greece.1253 , posix collation , character type. choose utf8 encoding, greek_greece.1253 charset/collation , input greek characters using ado connection (devart provider).

when make select using ado don't data expecting find(greek words) insteed weird looking characters (and think more expected).

i tring change collation , character type close utf-8 such greek_greece.utf-8 it's not available , allowed pgadmin.

my setup in windows.do have idea how make utf-8 available sellecting in charset type or how retrieve data in better way?

it looks os doesn't have support greek collation in utf-8.

you can see collations available postgresql following query:

select * pg_collation; 

greek el_gr.utf8. if listed, create database using query:

create database greek encoding 'utf-8' lc_collate='el_gr.utf8' lc_ctype='el_gr.utf8' template=template0; 

if not listed, need add language support @ os level.

i'm not familiar windows, memory there way add languages in control panel (not sure if adds utf-8 support though).

with debian linux it's easy:

$ dpkg-reconfigure locales 

in case, advise not use windows-1253 encoding in database. experience, non-utf8 data cause pain down road...