select * from agenda  WHERE to_ascii(nome, 'latin1') ilike 'JO%'

e eu estou usando o win1252


2008/5/5, Leandro DUTRA <[EMAIL PROTECTED]>:
>
> 2008/5/5 josemario rosa <[EMAIL PROTECTED]>:
> > deu certo valeu pela ajuda galera
>
> E qual foi a solução adotada?
>
> --
> skype:leandro.gfc.dutra?chat Yahoo!: ymsgr:sendIM?lgcdutra
> +55 (11) 3040 7300 r155 gTalk: xmpp:[EMAIL PROTECTED]<[EMAIL PROTECTED]>
> +55 (11) 9406 7191 ICQ/AIM: aim:GoIM?screenname=61287803
> +55 (11) 5685 2219 MSN: msnim:[EMAIL PROTECTED]
> _______________________________________________
> pgbr-geral mailing list
> [email protected]
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a