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 по дате отправления: