Re: [HACKERS] upper and lower doesn't work with german

Поиск
Список
Период
Сортировка
От Vincent.Gaboriau@answare.fr
Тема Re: [HACKERS] upper and lower doesn't work with german
Дата
Msg-id 3C0510FF.694D34EA@answare.fr
обсуждение исходный текст
Ответ на Re: [HACKERS] upper and lower doesn't work with german  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Ответы Re: [HACKERS] upper and lower doesn't work with german  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin

Tom Lane a écrit :

> Vincent.Gaboriau@answare.fr writes:
> >> You might be able to get it by looking through the
> >> <data dir>/global/pg_control file, but it's a binary file so you'll have
> >> to search for it.
>
> > I had found it, but I don't know speak fluent binary language  ;-)
> > Does a way exist to "decompile" it or to get informations on it?
>
> If you can't be troubled to compile up pg_controldata, then you'll
> have to resort to good old od:
>
> $ od -c pg_control
> 0000000 314 201 030 267 255   u 344 277  \0  \0  \0   G 013 355   p 253
> 0000020  \0  \0  \0 004   < 004   ) 006  \0  \0  \0  \0  \0  \0  \0   8
> 0000040  \0  \0  \0  \0   7 026   e 210  \0  \0  \0  \0   7 026   D   h
> 0000060  \0  \0  \0  \0   7 026   e 210  \0  \0  \0  \0  \0  \0  \0  \0
> 0000100  \0  \0  \0  \t  \0 001 357 235  \0 017 017 354   < 004   ) 004
> 0000120  \0  \0      \0  \0 002  \0  \0   C  \0  \0  \0  \0  \0  \0  \0
> 0000140  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0
> *
> 0000320  \0  \0  \0  \0  \0  \0  \0  \0   C  \0  \0  \0  \0  \0  \0  \0
> 0000340  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0
> *
> 0020000
>
> The LC_COLLATE and LC_CTYPE locale strings should be the last nonzero
> things in the file --- they're both "C" in this example.
>

Thanks to Tom Lane!
But I have This in my pg_control file:

# od -c pg_control
0000000  \0  \0  \0  \0 001  \0  \0  \0  \0  \0  \0  \0  \b  \0  \0  \0
0000020   ¤ 006 004   < 004  \0  \0  \0  \0      \0  \0  \0  \0 002  \0
0000040   ±   Õ   ë  \v  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0
0000060  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0  \0
*
0020000
#

So no LC_COLLATE and LC_TYPE in the pg_control. But these variables are set in
the user environement!


В списке pgsql-admin по дате отправления:

Предыдущее
От: Ming Du - Sun Microsystems
Дата:
Сообщение: can posgreSQL store data using raw device?
Следующее
От: Vincent.Gaboriau@answare.fr
Дата:
Сообщение: éèàïîù Problem