Re: [PERFORM] database encoding with index search problem

2005-08-16 Thread Richard Huxton
wisan watcharinporn wrote: problem: how can i configure database that can correct in sorting name and using index scan in like '%' search I think you'll want to read the following then have a quick search of the mailing list archives for "opclass" for some examples. http://www.postgres

[PERFORM] database encoding with index search problem

2005-08-16 Thread wisan watcharinporn
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 s