[DOCS] Application Note: Integrating Posgresql queries into an event loop.

2004-06-07 Thread Mark Harrison
Here's a note on using the async API. It's not runnable code (due to the variances in event loop packages), but I'm happy to add this to whatever documentation package is appropriate... Advice and feedback welcomed... Mark Application Note: Integrating Posgresql queries into an event loop. Mark H

Re: [DOCS] to_ascii function

2004-06-07 Thread Halley Pacheco de Oliveira
Dear Karel, The server encoding and the client encoding are LATIN1. These results are from phpPgAdmin: This is ok: select ascii('ª') ascii - 170 select chr(170) chr --- ª select to_ascii(chr(170)) to_ascii a But this is not ok! select ascii('º') ascii - 186 select chr(1

Re: [DOCS] to_ascii function

2004-06-07 Thread Karel Zak
On Sat, Jun 05, 2004 at 10:39:15AM -0300, Halley Pacheco de Oliveira wrote: > This query didn't work as I was expecting. Any reasons > for that ? > > SELECT TO_ASCII('ÁÉÍÓÚáéíóú??°') > > result -> 'AEIOUaeioua ' > > I used psql, java and phpPgAdmin without success. > > (PostgreSQL 7.4.2 encodi