| From: | "Leonardo M(dot)" Ramé <l(dot)rame(at)griensu(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Query inside RTF |
| Date: | 2009-10-08 13:58:05 |
| Message-ID: | 1255010285.2703.42.camel@leonardo-laptop |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi, in my database I store RTF files inside a Bytea field. Now a
customer is requesting a search inside RTF fields and I'm trying to
implement it by issuing this query:
select
*
from my_table
where
cast(rtf_field as varchar) like '%condition%'
This works ok when the condition doesn't include accented chars. RTF
escapes accented characters as "\'f1" for í, "\'f3" for ó, and so on.
To escape \ and ', I'd read it shuld be used \\ and '', so I thaugth
that a like '%diagn\\\\''f3stica%' should get "diagnóstica", but it
doesn't.
Any hint on this?
--
Leonardo M. Ramé
Griensu S.A. - Medical IT Córdoba
Tel.: 0351-4247979
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Massa, Harald Armin | 2009-10-08 14:56:43 | cost of query done - recorded anywhere? |
| Previous Message | shrikant hanagodimath | 2009-10-08 12:53:36 | Need info on PQfmod() |