string parsing
От | Jean-Christian Imbeault |
---|---|
Тема | string parsing |
Дата | |
Msg-id | 3D99B0FA.4080002@mega-bucks.co.jp обсуждение исходный текст |
Ответы |
COPY FROM stdin;
|
Список | 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
В списке pgsql-general по дате отправления: