From: | Grzegorz Przeździecki <Grzegorz(dot)Przezdziecki(at)PolskieSklepy(dot)pl> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Japanese characters problem |
Date: | 2005-03-18 16:34:17 |
Message-ID: | 200503181734.17963.Grzegorz.Przezdziecki@PolskieSklepy.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Welcome
Make some database and have problem with japanese characters maybe with other
too
Below some example
Linux system it is fedora (RH)
Locale for postgresql i pl_PL.utf8
Database is in uniqode
Thanks for help.
======================================================
[root(at)maciekb 1.0.4]# rpm -q postgresql
postgresql-7.4.7-3.FC3.1
[root(at)maciekb 1.0.4]# rpm -q postgresql-server
postgresql-server-7.4.7-3.FC3.1
crm=# select title,category from contentinfo ;
title | category
--------------------------------+----------
h264-charlie-900-hdd.avi | 洋画
h264-liloo-900-hdd.avi - drugi | 邦画
(2 rows)
crm=# select title,category from contentinfo where category='邦洋';
title | category
--------------------------------+----------
h264-charlie-900-hdd.avi | 洋画
h264-liloo-900-hdd.avi - drugi | 邦画
(2 rows)
crm=# select title,category from contentinfo where category='画洋';
title | category
--------------------------------+----------
h264-charlie-900-hdd.avi | 洋画
h264-liloo-900-hdd.avi - drugi | 邦画
(2 rows)
crm=# select title,category from contentinfo where category='洋';
title | category
-------+----------
(0 rows)
crm=# select title,category from contentinfo where category='画画';
title | category
--------------------------------+----------
h264-charlie-900-hdd.avi | 洋画
h264-liloo-900-hdd.avi - drugi | 邦画
(2 rows)
crm=# select title,category from contentinfo where category='画画画';
title | category
-------+----------
(0 rows)
crm=# select title,category from contentinfo where category ilike '画画';
title | category
-------+----------
(0 rows)
crm=# select title,category from contentinfo where category ilike '洋画';
title | category
--------------------------+----------
h264-charlie-900-hdd.avi | 洋画
(1 row)
crm=# select title,category from contentinfo where category ilike '邦画';
title | category
--------------------------------+----------
h264-liloo-900-hdd.avi - drugi | 邦画
(1 row)
crm=# select title,category from contentinfo where category ilike '邦画';
title | category
--------------------------------+----------
h264-liloo-900-hdd.avi - drugi | 邦画
(1 row)
crm=# \l
List of databases
Name | Owner | Encoding
-----------+-------+-----------
crm | sv | UNICODE
template0 | sv | SQL_ASCII
template1 | sv | SQL_ASCII
(3 rows)
crm=# select title,category from contentinfo where category ilike '%邦
画%';
title | category
--------------------------------+----------
h264-liloo-900-hdd.avi - drugi | 邦画
(1 row)
crm=# select title,category from contentinfo where category like '邦画';
title | category
--------------------------------+----------
h264-liloo-900-hdd.avi - drugi | 邦画
(1 row)
--
Grzegorz Przeździecki
www.PolskieSklepy.pl
kom. +48.606.822.506
gg:3701851 skype: grzegorz.przezdziecki
From | Date | Subject | |
---|---|---|---|
Next Message | Marco Colombo | 2005-03-18 17:05:16 | Re: plpython function problem workaround |
Previous Message | Rafael Martinez | 2005-03-18 16:18:28 | Re: pg_dump large-file support > 16GB |