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

Reply via email to