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.
======================================================
[EMAIL PROTECTED] 1.0.4]# rpm -q postgresql
postgresql-7.4.7-3.FC3.1
[EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
