Re: [GENERAL] Some Japanies charaters cannot be seen when using JDBC driver

2001-09-18 Thread Corn
I have the same problem. I setup an apache server /w JServ on linux machine. But when I access a unicode database. I only return ??? charachers. But I can read it correctly by odbc. It seems jserv cannot process unicode character. I read a homepage said that I can set jserv.properties about wrapp

Re: [GENERAL] Error in compiling PHP with PostgreSQL support

2001-09-18 Thread Cosmos Tong
Dear Mike, I am using SuSE 7.2. I compile Postgres, PHP, Apache, mod_ssl, mod_perl, MySQL, Imapd and Curl from source. The PHP is the last item I compiled. The following is the options I used to compile Postgres: --sysconfdir=/usr/local/etc --enable-syslog --enable-odbc --with-maxbackends=128

[GENERAL] Error in compiling PHP with PostgreSQL support

2001-09-18 Thread Cosmos Tong
Dear all, I can compile PHP 4.0.6 with Postgres 7.1.3 successfully. However, when I try to start apache, an error comes out: Cannot load /usr/local/apache/libexec/libphp4.so into server: /usr/local/apache/libexec/libphp4.so: undefined symbol: pg_encoding_to_char I would like to ask how can I

[GENERAL] PLPGSQL regexe

2001-09-18 Thread rdear
I'm doing a check within a PL/PGSQL function using a regular expression and I get the error: ERROR: regcomp failed with error invalid character range This appears to be because of the underscore "_" character. The regex I want to use is ''[A-Za-z0-9_]'' but this doesn't work. Any suggestions

Re: [GENERAL] locale and spanish acute

2001-09-18 Thread Tony Grant
On Mon, 2001-09-17 at 22:49, Martín Marqués wrote: > But I want it to work with más too. For that I would need to change that > query for this one: > > select count(*) from tab1 where to_ascii(col1) ILIKE to_ascii($1) > > Right? Right that will work because the content and the request is c

Re: [GENERAL] [HACKERS] MySQL development MUST immdediately cease - Due to

2001-09-18 Thread Justin Clift
To whoever sent this posting (being Al Dev, or someone spoofing), Please stop posting to the PostgreSQL mailing lists. You are not helping PostgreSQL with your postings, instead you are inciting anger and hostility. Cease and desist these postings immediately. Justin Clift peace_flower wrot

Re: [GENERAL] Ridicolus Postgresql review

2001-09-18 Thread Alessio Bragadini
Andrea Aime wrote: > If you want to get angry, take a look at: > http://www.iemagazine.com/010918/414feat3_1.shtml Seems that the article has been removed. I've sent a note to the editor, and he replied by asking if I wanted it published in the print edition, which I think will happen. -- Ales

Re: [GENERAL] Practical Cursors

2001-09-18 Thread Sam Tregar
On Mon, 17 Sep 2001, Command Prompt, Inc. wrote: > Is this truly the case, or is there a way for PostgreSQL to remember the > connection identifier so that the next time a PHP connection is made with > the same identifier a transaction can be completed? Anything is possible - you could write a s