postgresql v7.1.3 bug report

From: "pierre" <cti848(at)www(dot)textilenet(dot)org(dot)tw>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: postgresql v7.1.3 bug report
Date: 2001-09-04 06:59:16
Message-ID: 000801c1350f$26a03660$de00a8c0@www.textilenet.org.tw
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Dear Sir,

How are you. I need you help!

I make postgres 7.1.3 version in my linux system with --enable-multibyte=EUC_TW, but

I got some problem when I exec sql command below, in chinese character (CName ~* '帆'') the chicode is 0xA67C -> 0x7c is ascii '|" , I guess you system reject '|' this byte, but it was Big5 Code 2nd byte , How can I avoid this proble??

SELECT * FROM ifabinstn Where((CName ~* '帆') OR FALSE) ORDER BY CName

Warning: PostgreSQL query failed: ERROR: Invalid regular expression: empty expression or subexpression in DB/pgsql.php on line 163
ERROR: Invalid regular expression: empty expression or subexpression

would you give some advise to solve this problem??

Thank you very much

Best Rgds.
Pierre Ho

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2001-09-04 12:46:04 Re: linking with readline
Previous Message Bruce Momjian 2001-09-04 04:36:51 Re: Bug #432: Macaddr accepts empty string