Re: accented vowels, regexp, headache...
| From: | Jamie Alessio | Date: | Fri, 03 Nov 2000 17:44:01 +0000 |
| Subject: | Re: accented vowels, regexp, headache... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-4196@lists.php.net to get a copy of this message | ||
> $fragment= strtoupper(function(...));
> $query="Select * from table where upper(field)='$fragment'"
> $result=...
>
Why not replace the second line with:
$query = "Select * from table where upper(field) = upper('$fragment')";
There isn't is good reason to use PHP's string function to uppercase when you can just do
it in the query. That should take care of your locale problems.
- Jamie