ProblemWithCharsOSX
От | Angel Zúñiga |
---|---|
Тема | ProblemWithCharsOSX |
Дата | |
Msg-id | CAB849dZdwFxtVCmUz9JMyyGh_aaOeUw=Vs=-EsoNiZrMZ0VD+w@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: ProblemWithCharsOSX
|
Список | pgsql-bugs |
Hi there,<br /><br />I'm a PostgreSQL user in the linux world but at the office there is a Mac computer and I have a problemwith postgres in it.<br /><br />The problem is when I use characters with tildes in spanish like in the follow word"países".<br /> The next is ilustrates my problem:<br /><br />test=# SHOW SERVER_ENCODING;<br /> server_encoding <br/>-----------------<br /> UTF8<br />(1 row)<br /><br />test=# SELECT pg_client_encoding();<br /> pg_client_encoding <br/>--------------------<br /> UTF8<br />(1 row)<br /><br />test=# CREATE TABLE países (nombre VARCHAR(10));<br />CREATETABLE<br />test=# \d<br /> List of relations<br /> Schema | Name | Type | Owner <br />--------+-------+-------+--------<br/> public | pases | table | dragon<br /> (1 row)<br /><br />The table name is createdwithout the "í" character but if I enclose the string between quotes postgres works fine.<br />test=# CREATE TABLE"países" (nombre VARCHAR(10));<br />CREATE TABLE<br /> test=# \d<br /> List of relations<br /> Schema | Name | Type | Owner <br />--------+--------+-------+--------<br /> public | países | table | dragon<br /> public | pases | table | dragon<br />(2 rows)<br />test=# \l<br /> List of databases<br /> Name | Owner | Encoding | Collation | Ctype | Access privileges <br />-----------------+----------+----------+-------------+-------------+-----------------------<br/> template0 | postgres| UTF8 | es_MX.UTF-8 | es_MX.UTF-8 | =c/postgres +<br /> | | | | | postgres=CTc/postgres<br /> template1 | postgres | UTF8 | es_MX.UTF-8 | es_MX.UTF-8| postgres=CTc/postgres+<br /> | | | | | =c/postgres<br/> test | dragon | UTF8 | es_MX.UTF-8 | es_MX.UTF-8 | <br /><br /><br />In the linux boxall works fine, so I think the problem is something particular to Mac,<br />The Mac OS X version is 10.7.4.<br />DarwinUsers-iMac.local 11.4.0 Darwin Kernel Version 11.4.0: Mon Apr 9 19:32:15 PDT 2012; root:xnu-1699.26.8~1/RELEASE_X86_64x86_64<br /><br />and the postgres version is 9.0.8. <br /><br />Can Anybody help me withmy problem?<br /><br /><div style="text-align:right">Thanks in advance,<br />Angel <br /></div><br /><br /><br /> <br/><br />
В списке pgsql-bugs по дате отправления: