PostgreSQL encoding yada yerellestirme problemi

From: "ZEKI CATAV" <zcatav(at)isnet(dot)net(dot)tr>
To: PostgreSQL Turkiye <pgsql-tr-genel(at)postgresql(dot)org>
Subject: PostgreSQL encoding yada yerellestirme problemi
Date: 2003-09-28 11:19:25
Message-ID: 200309281419.25950.zcatav@isnet.net.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-tr-genel

SQL hatasi:
HATA: 'clýent_encodýng' is not a valid option name

Ustteki hata, asagidaki ifade icinde olustu:
SET CLIENT_ENCODING TO 'LATIN5'

Istemci dil kodlamasini ayarlamaya calisirken bir hata olustu.
--------------------------------------------------------------------------------
SQL hatasi:
HATA: 'clýent_encodýng' is not a valid option name

Ustteki hata, asagidaki ifade icinde olustu:
SET CLIENT_ENCODING TO 'SQL_ASCII'

Istemci dil kodlamasini ayarlamaya calisirken bir hata olustu.
-----------------------------------------------------------------------------------

MDK 9.1 (Bamboo) yuklu bir makinede phpPgAdmin 3.0.1 ile psql 7.3.2, the
PostgreSQL uzerinde veritabanina ulasmaya calisirken yukaridaki hatayi
aliyorum.

postgres, catav ve root user icin locale;
LANG=tr_TR
LC_CTYPE=tr_TR
LC_NUMERIC=tr_TR
LC_TIME=tr_TR
LC_COLLATE=tr_TR
LC_MONETARY=tr_TR
LC_MESSAGES=tr_TR
LC_PAPER=tr_TR
LC_NAME=tr_TR
LC_ADDRESS=tr_TR
LC_TELEPHONE=tr_TR
LC_MEASUREMENT=tr_TR
LC_IDENTIFICATION=tr_TR
LC_ALL=
seklinde.
-------------------------------------------------------------------------
List of databases
Name | Owner | Encoding
------------+----------+-----------
dene | postgres | LATIN5
deneme | catav | SQL_ASCII
deneme3 | catav | SQL_ASCII
hasta | catav | SQL_ASCII
phppgadmin | postgres | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
test | catav | SQL_ASCII
(8 rows)

///////////////////////////////////////////////////////////////////////////////////////////
****************************************************
KONSOLDA (xkonsolu ve standart konsol):
****************************************************
[catav(at)localhost catav]$ psql dene
Welcome to psql 7.3.2, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

dene=#

---------------------------------------------------------------------------
[catav(at)localhost catav]$ psql deneme
Welcome to psql 7.3.2, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

deneme=#
------------------------------------------------------------------------------
dene=# SHOW CLIENT_ENCODING;
HATA: Option 'client_encoding' is not recognized
dene=#
dene=# SHOW CLiENT_ENCODiNG;
client_encoding
-----------------
SQL_ASCII
(1 row)

dene=#
-------------------------------------------------------------------------------
problemi disinda sorunsuz olarak calisiyorum.
Postgres, root ve catav kullanicilarinin locale ayarlarini localedrake ile
degistirmeyi root ve catav icin en_US oldu ama postgres icin basarili olmadi,
tr_TR olarak kaldi. Hata olarak "Xlib: connection to ":0.0" refused by server
Xlib: No protocol specified" verdi. Postgres icin locale en_US olabilse sorun
cozulur mu?
Bu problemin cozumu icin onerileriniz nedir? Tesekkur ederim.
Hoscakalin.

--
Zeki Çatav
catav(at)isbank(dot)net(dot)tr
http://catav.kolayweb.com

Responses

Browse pgsql-tr-genel by date

  From Date Subject
Next Message Devrim GUNDUZ 2003-09-28 12:47:15 Re: PostgreSQL encoding yada yerellestirme problemi
Previous Message Devrim GUNDUZ 2003-09-28 09:45:34 pgAdmin III v1.0.0 duyuruldu.