2009/10/8 Leonardo M. <l.rame@xxxxxxxxxxx>: > 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? first, try dollar quoting: cast(rtf_field as varchar) like $merlin$%condition%$merlin$ :-) merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
