<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi, All,<br>
</p>
<p>Thanks to Peter and Andrew. I have solved the local-infile
problem in mysql. However, I encountered a new problem of query
with regular expressions. This means I cannot used regular
expression in either CQP syntax or Simple query mode.</p>
<p>I have installed the two packages of libpcre3 and libpcre3-dev (I
am using an ubuntu server), and its pcretest returns:</p>
<p>_________</p>
<p>PCRE version 8.43 2019-02-23<br>
Compiled with<br>
8-bit support<br>
UTF-8 support<br>
Unicode properties support<br>
......<br>
</p>
<p>________</p>
<p>but I still got the error message:</p>
<p>______________</p>
<p class="errormessage">**** CQP ERROR ****</p>
<p class="errormessage">CL: Regex Compile Error: this version of
PCRE is not compiled with Unicode property support</p>
<p class="errormessage">CQP Error:</p>
<p>__________________</p>
<p>Any pointers?</p>
<p>Best,</p>
<p>D.<br>
</p>
</body>
</html>