string parsing

From: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: string parsing
Date: 2002-10-01 14:28:10
Message-ID: 3D99B0FA.4080002@mega-bucks.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ok, this may sounds strange but ...

I have user input that is in japanese and I need to parse it. I am using
PHP and PostgreSQL but PHP's multi-byte string parsing functions don't
seem to be working (still experimental).

So my hack is to put the strings into the DB and have postgreSQL do the
parsing for me since postgreSQL doesn't seem to have any trouble
handling multi-byte strings as far as my testing as shown.

Now for the strange request ....

Is there an SQl query that will parse a string on a separator (whites
pace) and return one word per row in the result set? (I don't know *any*
perl so I can't write a PL/PGSQL function, and I'm worried that a perl
function wouldn't be multi-byte safe ...)

Sorry to ask such an OT question but I've been trying the various string
functions of pg and so far I have been able to do this ...

Thanks,

Jc

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben-Nes Michael 2002-10-01 14:40:10 Re: Major Problem with locale
Previous Message Tom Lane 2002-10-01 14:07:28 Re: cluster replication with intermezzo