SELECT 'abc'::text || 'def'::text;
it's working fine (no need to convert the query ASCII to UTF8 or such
i am using pgadmin (1.8.2) to pass the query:
show client_encoding = UNICODE.
in postgresql.conf i have:
client_encoding; Value = UTF8, Current value = UNICODE;
i tried to restart postgresql for reloading his configuration, but it's
still UNICODE...
reinstalling postgresql 8.3.1 on windows and leaving the server encoding and
client encoding to default (cannot remember what was it - something like
WIN1252 or such) then i have no more problem, but i am worry about the
impact of transfering the database to linux (eventually i would like to
transfer my database to my linux server)...
pat