[GENERAL] unicode searches failing that use % and LIKE operators

xt LIKE '%Smith%' What must I do to ensure that mixed-term searches of the first kind succeed? Thanks in advance, Ben Weaver -- Benjamin Weaver Faculty Research Associate, Imaging Papyri Projects, Herculaneum Society, Oxford email: [EMAIL PROTECTED] phone: (

Re: [GENERAL] unicode searches failing that use % and LIKE operators

Tom, Thanks. I am running: Postgres 8.1.4 server_encoding UTF8 lc_collate en_GB.UTF-8 lc_ctype en_GB.UTF-8 Ben In message <[EMAIL PROTECTED]> Tom Lane <[EMAIL PROTECTED]> writes: > Benjamin Weaver <[EMAIL PROTECTED]> writes: > > I have the following

Re: [GENERAL] unicode searches failing that use % and LIKE operators

Tom, To be more precise, the mixed queries "fail" in that they return hits of 0 rows, when they should return more than 0 rows. Ben In message <[EMAIL PROTECTED]> Tom Lane <[EMAIL PROTECTED]> writes: > Benjamin Weaver <[EMAIL PROTECTED]> writes: > > I ha

Re: [GENERAL] unicode searches failing that use % and LIKE operators

server box. Ben In message <[EMAIL PROTECTED]> Gregory Stark <[EMAIL PROTECTED]> writes: > "Benjamin Weaver" <[EMAIL PROTECTED]> writes: > > > Tom, > > > > Thanks. I am running: > > > > Postgres 8.1.4 > > server_encoding

Re: [GENERAL] unicode searches failing that use % and LIKE operators

PROTECTED]> writes: > Benjamin Weaver <[EMAIL PROTECTED]> writes: > > I AM in fact running the db on Linux. Redhat 9. Are the encoding parameters > > wrong for Linux? > > Hmm ... RH 9 is awfully old. It's at least conceivable that you're > getting bit by so

Re: [GENERAL] unicode searches failing that use % and LIKE operators

down read-write-create-selete software! Thanks again for your help, Ben In message <[EMAIL PROTECTED]> Tom Lane <[EMAIL PROTECTED]> writes: > Benjamin Weaver <[EMAIL PROTECTED]> writes: > > I AM in fact running the db on Linux. Redhat 9. Are the encoding paramete

[GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

L5335 2.0 GHz. 2. Are there performance problems running PostGreSQL 8.3 on a 64-bit processor? Thanks in advance. Yours Ben Weaver -- Benjamin Weaver Faculty Research Associate, Imaging Papyri, Greek Fragments Projects, Oxford email: [EMAIL PROTECTED] phone: (0)1865 610236 -- Sent via

Re: [GENERAL] compiling, performance of PostGreSQL 8.3 on 64-bit processors

ere you need to know your way around a Makefile..." In message <[EMAIL PROTECTED]> Tom Lane <[EMAIL PROTECTED]> writes: > Greg Smith <[EMAIL PROTECTED]> writes: > > On Thu, 26 Jun 2008, Benjamin Weaver wrote: > >> I have heard of problems arisi

[GENERAL] explosion of tiny tables representing multiple fields--Is this necessary?

although I have a fair amount of experience with SQL, this profusion of tables would be a pain to implement. But I don't see any way around creating them when the relation between the MyTextObject and the various fields is one-to-many. -- Benjamin Weaver Faculty Research Associate, Im

Re: [GENERAL] explosion of tiny tables representing multiple

ge <[EMAIL PROTECTED]> Benjamin Weaver <[EMAIL PROTECTED]>, pgsql-general@postgresql.org writes: > On Thu, Nov 02, 2006 at 04:36:49PM +, Benjamin Weaver wrote: > > Dear PostGreSQL experts, > > > > > > I am working with text objects. A text object will have l