character sequence problem

Поиск
Список
Период
Сортировка
От Vincent.Gaboriau@answare.fr
Тема character sequence problem
Дата
Msg-id 3BFE04A0.922FC3E7@answare.fr
обсуждение исходный текст
Список pgsql-admin
Hi all,

A cursious problem occurs with some character sequences with french
characters.
I have seen lots of things on the internet to solve this foreign
charater problem but nothing works!
I have PostgreSQL v 7.0.2 under Linux.

I give you some expemple under psql ("intradev" is the database name):

***************************** EXAMPLE
*************************************
intradev=> \d pipo
          Table "pipo"
 Attribute |   Type   | Modifier
-----------+----------+----------
 test1     | char(50) |
 test2     | char(50) |

intradev=> select * from pipo where test1 like '%Coordination%';
 test1 | test2
-------+-------
(0 rows)

intradev=> select * from pipo where test1 like '%oordination%';
                       test1
|                       test2
----------------------------------------------------+----------------------------------------------------

 Comité Coordination                                | Test
(1 row)

intradev=> select * from pipo where test1 like '% Coordination%';
 test1 | test2
-------+-------
(0 rows)

intradev=> select * from pipo where test1 like '%é Coordination%';
                       test1
|                       test2
----------------------------------------------------+----------------------------------------------------

 Comité Coordination                                | Test
(1 row)

*************************END OF EXAMPLE
*************************************

As you can see the 'é' character make mistakes with the 2 following
characters.
Perhaps do you need more information ? So...
    - The database encode is UNICODE (with "\encoding" comand).
    - The local variables are:
            LC_MESSAGES=fr_FR
            LC_TIME=fr_FR
            LC_NUMERIC=fr_FR
            LC_CTYPE=fr_FR
            LC_MONETARY=fr_FR
            LC_COLLATE=fr_FR

To start the postmaster, how can I know the backends options list? And
what is the option -o "-Fe"  for example?
Another question (the last but not the least ;-) )! How can I know if
PostgreSql has been installed with the local configuration support (It's
not me who had installed PostgreSQL and The SRCs are not anymore present
on the computer).

Thanks,

Vincent.


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: stuck spinlock
Следующее
От: Ludva Radomír (KM)
Дата:
Сообщение: Machine independent performance.