X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 02F9052ECA for ; Sat, 13 Aug 2005 00:27:56 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 48831-01 for ; Sat, 13 Aug 2005 03:27:53 +0000 (GMT) Received: from hotmail.com (bay18-f15.bay18.hotmail.com [65.54.187.65]) by svr1.postgresql.org (Postfix) with ESMTP id 5F8E652EC2 for ; Sat, 13 Aug 2005 00:27:52 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 12 Aug 2005 20:27:52 -0700 Message-ID: Received: from 203.144.143.7 by by18fd.bay18.hotmail.msn.com with HTTP; Sat, 13 Aug 2005 03:27:51 GMT X-Originating-IP: [203.144.143.7] X-Originating-Email: [maccran@hotmail.com] X-Sender: maccran@hotmail.com From: "wisan watcharinporn" To: pgsql-admin@postgresql.org Subject: database encoding problem Date: Sat, 13 Aug 2005 03:27:51 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 13 Aug 2005 03:27:52.0055 (UTC) FILETIME=[FC971070:01C59FB6] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.776 tagged_above=0 required=5 tests=[DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, MSGID_FROM_MTA_HEADER=0, RCVD_IN_NJABL_PROXY=1.026] X-Spam-Level: ** X-Archive-Number: 200508/168 X-Sequence-Number: 18487 i have problem in database encoding with indexing case :1 when i initdb -E win874 mydb and create database with createdb -E win874 dbname and create table emp with index in empname field i can select sorting name correct in thai alphabet such select empName from emp order by empName; but in select empName from emp where empname like 'xxx%' it not using index scan , it use seq scan so it may slow in find name case :2 when i initdb mydb (use default) and create database with createdb -E win874 dbname and create table emp with index in empname field i can not select sorting name correct in thai alphabet but in select empName from emp where empname like 'xxx%' it using index scan , very fast in find name problem: how can i configure database that can correct in sorting name and using index scan in like 'xxxx%' search using FreeBSD 5.4 postgreql 8.0. _________________________________________________________________ Don't just search. Find. Check out the new MSN Search! http://search.msn.com/