_unicode_ci.
> I have had the inverse problem and I solved with utf8_general_ci.
>
> Santino
>
> At 19:33 +0100 16-02-2009, Salam Baker Shanawa wrote:
> >Hi,
> >
> >How can I have accent sensitive, case insensitive fulltext query?
> >
> >version: 5.0.45
&
Hi,
How can I have accent sensitive, case insensitive fulltext query?
version: 5.0.45
The database, tables, connection, data etc. are all utf8.
select name from people where match(name) against ('"königsberger"' in
boolean mode);
shouldn't return konigsberger.
Any idea, collation?
Rega
cords
from the 1st query to be presented (each record will have it's own peopleID)
you have to add something like this to the url which will be then read by the
update script.
yourUpdateScript?id=$peopleID
Salam
On Sunday, June 29, 2003, at 02:29 AM, Salam Baker Shanawa wrote:
Hi Ted,
1. Modify the query which presents all records by selecting let's say the
peopleID.
2. When you build your update link you can use that ID to ask for a particular
record.
3. Then you can use the same query +
" AND peopleID=THE_ID_OF_THAT_RECORD_EXTRACTED_FROM_THE_LINK".
something like
If you haven't done this:
run "mysql_install_db" to create the privilege tables db, host, user in
"mysql" directory below the new directory. The script 'll create the test
directories too.
Regards
Salam
[EMAIL PROTECTED] wrote:
Hi. Anyone know the trick to successfully using a different
Try this:
SELECT * FROM MyTable WHERE RefList not regexp "(^|[^0-9])MyNum([^0-9]|$)";
Regards
Salam
Jeff Snoxell wrote:
Hi,
I've got a varchar field in a mysql table that contains 'N' numbers
(each a maximum of 4 digits, not zero padded) separated by spaces when
more than 1 number is prese
Hi Jeff,
Try the magic undef as it is with no '' or ""
$dbh->do('insert into yourtab values (' .
join (',', map($dbh->quote($_), $your_stuff, undef, $more_stuff)) .
')') ;
Regards
Salam
Jeff Snoxell wrote:
Hello,
I've got a mysql table with a lot of fields and I'm using a map
Hi,
As of Version 4.0.1 you can use the truncation operator * in boolean mode:
select firstname from contacts where match(firstname,lastname) against
('steff*' in boolean mode);
This will match steff , steffa, steffan, steffane, steffans
But of course not "stef" unless you use 'stef*' .
R
Hello Victoria,
Is there any plan to make operators work with phrase searches.
something like: against ('"comput* scie*"') in boolean mode
I have tested 4.0.6-gamma and I can see that the bug is fixed:
Empty set is returned when truncation operator is used :-)
Regards
Salam
Victoria Reznichenko
Hello,
I need un explanation to the following, or it is a bug which needs a
fix.
mysql> select ti from article where match (ti) against ('"computer
science"' in boolean mode) ;
.
21 rows in set (0.07 sec)
Now using the truncation operator *
mysql> select ti from article where match (ti
10 matches
Mail list logo