g the table as such might be
>the best solution in this case entirely, depending on the environment.
>Another option is just to use utf8_bin as collation, but grouping by
>LOWER(yourcolumnname), or if that's not enough performance, denormalizing
>into an extra lowercase column.
>
ame), or if that's not enough performance, denormalizing
into an extra lowercase column.
On Mon, Nov 24, 2014 at 11:36 PM, Martin Mueller <
martinmuel...@northwestern.edu> wrote:
> Is there a unicode setting on mysql that is case insensitive but
> diacritics sensitive? Given
Is there a unicode setting on mysql that is case insensitive but
diacritics sensitive? Given 'Ete', 'été', 'ete' a group by routine for
such a setting would return two values: 'été', 'ete'. I couldn't find
it, but I may not have know
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_lower_case_table_names
I think you'll want to set it to 1
On Wed, Mar 18, 2009 at 22:15, David M. Karr wrote:
> Ubuntu 8.10.
>
> I was experimenting with the Spring Petclinic sample application, configured
> with MySQL.
Ubuntu 8.10.
I was experimenting with the Spring Petclinic sample application,
configured with MySQL. I found that some of the tests were failing,
apparently because of table name case-sensitivity issues. I was able to
fix some of the code references, but after that I hit other, probably
fo
How can I use REGEXP case insensitive SQL QUERY
Ex: select * from table where a REGEXP 'abc' will match both 'abc' and 'ABC'
On 10/16/06, mos <[EMAIL PROTECTED]> wrote:
Timothy,
You can make the varchar column case sensitive by using the
binary
attribute or use the isstrcmp(value1,value2) for an exact match.
See http://lists.mysql.com/mysql/170390
varchar(255) binary
or select binary 'a'='A' ...
Mike
T
At 08:26 AM 10/15/2006, you wrote:
Hi,
My MySQL on Debian is on version "4.0.24_Debian-10sarge1-log". I have a
varchar(255) as a primary key for a table. I have found the primary key case
insensitive. Is this normal? This is not the behavior I prefer. Any help
would be appreciat
On 10/15/06, Timothy Wu <[EMAIL PROTECTED]> wrote:
Hi,
hi
My MySQL on Debian is on version "4.0.24_Debian-10sarge1-log". I have a
varchar(255) as a primary key for a table. I have found the primary key
case
insensitive. Is this normal?
Yes, it's normal!
To fo
Hi,
My MySQL on Debian is on version "4.0.24_Debian-10sarge1-log". I have a
varchar(255) as a primary key for a table. I have found the primary key case
insensitive. Is this normal? This is not the behavior I prefer. Any help
would be appreciated, thanks.
Timothy
What is the best (most optimal) way to perform a case-insensitive search
for a VARCHAR column with COLLATE utf8_bin?
I'm assuming the answer is not:
SELECT *
FROM MyTable
WHERE UPPER(MyColumn) LIKE Upper('%pattern%');
Tia!
R.
--
MySQL General Mailin
You should use:
SELECT username FROM workflow.user WHERE username LIKE BINARY 'NicO' LIMIT
1;
reference:
http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html
On 12/12/05, Nico Sabbi <[EMAIL PROTECTED] > wrote:
>
> Hi,
> my mysql always executes
Nico Sabbi wrote:
Hi,
my mysql always executes case insensitive queries:
SELECT username FROM workflow.user WHERE username = 'NicO' LIMIT 1;
+--+
| username |
+--+
| nico |
+--+
1 row in set (0.01 sec)
that field is of varchar(255) type.
I don't
Hi,
my mysql always executes case insensitive queries:
SELECT username FROM workflow.user WHERE username = 'NicO' LIMIT 1;
+--+
| username |
+--+
| nico |
+--+
1 row in set (0.01 sec)
that field is of varchar(255) type.
I don't understand the
try no. 12 will be shown.
> If I search for *Afan* only entry no. 13 will be shown.
> If I search for *AFAN* only entry no. 14 will be shown.
Then the collation in use is either case sensitive or binary. To find all
three entries you want a case insensitive collation – one with a name that
* only entry no. 13 will be shown.
If I search for *AFAN* only entry no. 14 will be shown.
?!?
Thanks.
-afan
Jasper Bryant-Greene wrote:
[EMAIL PROTECTED] wrote:
but I'm getting case insensitive search?!? it's not the same I enter
afan or Afan or AFAN!??
Your two statements
It's not clear to me whether you want the search to be case sensitive or not,
but you need to make sure that the right collation is used. Case sensitive
collations end in "_cs" and case insensitive collations end in "_ci".
Read about collations in chapter 10 of the man
on 11/18/05 2:27 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:
> but I'm getting case insensitive search?!? it's not the same I enter
> afan or Afan or AFAN!??
>
> Any ideas?
Set the field type to binary, or use your php to compare the result
[EMAIL PROTECTED] wrote:
but I'm getting case insensitive search?!? it's not the same I enter
afan or Afan or AFAN!??
Your two statements contradict each other. Either you are getting case
insensitive search, meaning that it *is* the same if you enter afan,
Afan or AFAN, or you&
SOC))
{
$SALESMEN[] = preg_replace("/$SearchSalesperson/", "style=\"background-color: gold;\">$SearchSalesperson", $result);
}
}
but I'm getting case insensitive search?!? it's not the same I enter
afan or Afan or AFAN!??
Any ideas?
Thanks for any
You're right. The LIKE comparison only works properly with the Latin
letters in utf8. MySQL hasn't yet fixed it to work with the rest of Unicode
yet. I believe there is a valid LIKE comparison for ucs2. From what I
remember, however, it has problems too if you start putting wildcards at the
Hello and sorry for a dumb question, but this is my third day of experimenting
and surprisingly no luck with archives, so:
Is UTF-8 case insensitive search OK?
set @@character_set_client=utf8;
set @@character_set_server=utf8;
set @@character_set_connection=utf8;
set @@character_set_results=utf8
Sorry about the double posts...
But I forgot something...
On Friday 28 November 2003 14.51, Lemasson Sylvain wrote:
> Can something be done so that mysql be case sensitive ?
If you only need case-sentivitity on selects read this:
http://www.mysql.com/doc/en/Case_Sensitivity_Operators.html
" The B
On Friday 28 November 2003 14.51, Lemasson Sylvain wrote:
> Hello,
Hi
> The first think is that I cannot add a primary constraint on test because
> Mysql do not make the difference between 'bla' and 'BLA'. It is case
> insensitive. I have the same problem whe
aint on test because Mysql do not
make the difference between 'bla' and 'BLA'. It is case insensitive.
I have the same problem when I do: select * from test where value='bla'. The select
return two lines when just one was expected.
The version of Mysql i
On Fri, 30 May 2003, Jeremy March wrote:
> The problem is that querying with a LIKE expression is treated case
> and accent sensitive. [...] Has anyone else experienced this with
> multibyte utf8?
Yes. mysql-standard-4.1.0-alpha-pc-linux-i686 running with
--default-character-set=utf8 gives me:
hat the utf8 cs uses the "simple" LIKE function--could
that be the problem? LIKE works correctly (case insensitive) for the Latin unicode
range, I assume because it isn't multibyte.
Has anyone else experienced this with multibyte utf8?
Thanks,
Jeremy March
>Description:
REGEXP and LIKE operators in SELECT statements will NOT
do case-insensitive queries in VARCHAR() and BLOB text
columns.
E.g.
SELECT * FROM article_database WHERE article_preview LIKE '%a%';
'%a%' LIK
Hi Andreas,
On Sat, 2002-02-16 at 08:52, Andreas Frøsting wrote:
> Why does MySQL have this strange behavoir, treating unique indexes
> case-insensitive?
> Can anyone explain MySQL's behaviour and how I do a workaround making
> unique indexes and primary keys case sensitive?
>
, 1 row affected (0.00 sec)
mysql> insert into flaf VALUES ('Hest');
ERROR 1062: Duplicate entry 'Hest' for key 1
Here, the unique index sees "Hest" as "hest", and because of that the
second row is not inserted.
Why does MySQL have this strange behavoir,
Hi!
i'm converting some database from windows mysql to freebsd. Program
wich uses this database is written very bad (not mine) and did not
correctly call querries.
Problem is with case sensitivity of unix. Is there any way to tell
mysql on unix that SELECT * FROM table is ste same as SELECT * FR
Bennet> MySQL documentation says that CHAR and VARCHAR types are case-insensitive:
Bennet> http://www.mysql.com/doc/C/H/CHAR.html
Bennet> But I have a table with a column of type VARCHAR(255), and if I do a query
Bennet> like
Bennet> select * from user where
Hi Bennett!
On Wed, 14 Nov 2001, Bennett wrote:
> I did try
> select * from user where 'Bennett' LIKE emailaddress;
>
> but it returned 0 results; in fact, so did
> select * from user where 'bennett' LIKE emailaddress;
I didn't think that through too well, did I. :) See the Doc for 'Pattern
Mat
MySQL documentation says that CHAR and VARCHAR types are case-insensitive:
http://www.mysql.com/doc/C/H/CHAR.html
But I have a table with a column of type VARCHAR(255), and if I do a query
like
select * from user where LOCATE('Bennett', emailaddress) > 0;
then the results
>Description:
When a field contains multiple lines (delimited by \n)
SELECT ... WHERE xxx like "%xxx%" is no longer case
insensitive.
>How-To-Repeat:
create table test (
text blob
);
insert into test values ("Hello\nWorld\nTest")
hallo!
in my table i have a column with the caracter char and binary.
how can i search case insenitive?
--
Gruß & bye
Michael Ott
-
- Siemens AG - I&S IT PS 51 ERL -
- Werner-von-Siemens-Strasse 60 -
- 91050 Erlangen-
- Tel. +49 91 31 7 42
Hi!
Is there a case insensitive version of 'InStr' function in MySql ?
I need to search a database for secified substring.
This can be done by function InStr which "Returns the position of the first
occurrence of substring substr in string str".
There are also functions nam
Andis Grasis wrote:
> Hi!
>
> I have such SQL :
>
> select CompanyName from Company where CompanyName like '%car%'
>
> Really I need in query result all of companys, which contains symbols CAR in any
>case (car, Car,CAr, CAR, e.t.c).
> I think that I need Ca
----+
| 0 |
+--+
1 row in set (0.00 sec)
It's already case insensitive.
> Hi!
>
> I have such SQL :
>
> select CompanyName from Company where CompanyName like '%car%'
>
> Really I need in query result all of companys, which contains
Hi!
I have such SQL :
select CompanyName from Company where CompanyName like '%car%'
Really I need in query result all of companys, which contains symbols CAR in any case
(car, Car,CAr, CAR, e.t.c).
I think that I need Case insensitive records search.
Is it's possible and how
Tom Svensson wrote:
>
> Hi!
>
> I'm using version 3.23.37 of MySQL (for Windows). Why does REGEXP
> seems to be case insensitive?
> Queries like
> SELECT "tom" REGEXP "tOm";
> returns 1 Why? And how ca
Hi!
I'm using version 3.23.37 of MySQL (for Windows). Why does REGEXP
seems to be case insensitive?
Queries like
SELECT "tom" REGEXP "tOm";
returns 1 Why? And how can I solve it (to return 0)?
Regards,
Tom S.
---
Hi,
Do you mean case insensitive when you do a like?
a like is case insensitive, to make it sensitive do a LIKE BINARY 'abc',
or use CLIKE (from memory, might be wrong).
Robin
-Original Message-
From: Carfield Yim [mailto:[EMAIL PROTECTED]]
Sent: 02 March 2001 10:42
T
2001 18:42
Subject: Do index in MySQL is case insensitive?
> I have heard from somebody that MySQL index is case insensitive. If this
is
> true, how can I set it to case sensitive?
>
-
Before posting, please check:
I have heard from somebody that MySQL index is case insensitive. If this is
true, how can I set it to case sensitive?
45 matches
Mail list logo
