Hello,
I am using MySql-5.0.21 on Suse-Linux-10, i created tables using
lowercase names
for example ;
mysql create table a (id int);
Query OK, 0 rows affected (0.04 sec)
mysql select * from A;
ERROR 1146 (42S02): Table 'mysql.A' doesn't exist
mysql select * from a;
Empty set (0.01 sec)
I have
Hi,
yes it makes a huge difference,
as the tables are stored in files and therefore if
the filesystem is case-insensitive (Windows) you can
use either case in your queries, while on a case-sensitive
filesystem (linux etc) you can't.
See:
This isn't caused by MySQL. It's an OS issue. Linux and Unix are case
sensitive operating systems so any program you run, unless it is
specifically written to be NON-case sensitive, is case sensitive as well.
Jack
-Original Message-
From: Andre MATOS [mailto:[EMAIL PROTECTED]
Sent:
But this issue can be handled by MySQL. Take a look at the
lower_case_table_names system variable. With lower_case_table_names=1 on
the Linux/Unix server, table names will be stored as lower case. See the
manual http://dev.mysql.com/doc/mysql/en/Name_case_sensitivity.html for
the details,
you can add
`lower_case_table_names = 1` to the my.cnf to ignore table name sensitivity.
-Original Message-
From: Andre MATOS
To: [EMAIL PROTECTED]
Sent: 5/12/04 9:53 AM
Subject: Case Sensitive
Hi List,
I have three MySQL servers. One is running on Windows XP, another on
MacOS
X, and
shaun thornburgh wrote:
Hi,
I am trying to synchronize two databases - the source is on a FreeBSD
web server and the target is on our local Windows 2000 Server machine.
I am trying to do this using Webyog (www.webyog.com) which tells
Windows to sync with the source machine every hour.
Side
At 14:43 + 4/30/04, shaun thornburgh wrote:
Hi,
I am trying to synchronize two databases - the source is on a
FreeBSD web server and the target is on our local Windows 2000
Server machine. I am trying to do this using Webyog (www.webyog.com)
which tells Windows to sync with the source
From the MySQL manual
A.5.1 Case-Sensitivity in Searches
By default, MySQL searches are case-insensitive (although there are
some character sets that are never case-insensitive, such as czech ).
That means that if you search with col_name LIKE 'a%' , you will get
all column values that
gord barq [EMAIL PROTECTED] wrote:
I'm using MySQL 4.1 so how do I define case sensitive collation? Is it on
the columns or on the indexes?
On column. Look at the collations of your character set using SHOW COLLATION command:
http://www.mysql.com/doc/en/Charset-SHOW-COLLATION.html
Hi Gord,
I understood that searches in general arecase insensitive (but I might be
wrong of course).
Try to use the word BINARY when creating the table or when making a SELECT.
I am not sure how you would have to apply this to the index.
Best regards
Nils Valentin
Tokyo/Japan
2003 8 26
gord barq [EMAIL PROTECTED] wrote:
I have the following index:
CREATE UNIQUE INDEX SongTopic_idx ON SongTopic(songTitle, artist, album);
Where songtitle, artist and album are varchar() columns.
It appears that this index is not case sensitive. Is that correct? If so,
how can I have it
I'm using MySQL 4.1 so how do I define case sensitive collation? Is it on
the columns or on the indexes?
Thanks.
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Case sensitive indexes
Date: Tue, 26 Aug 2003 13:18:19 +0300
gord barq [EMAIL PROTECTED] wrote:
I
: Matt Gostick [EMAIL PROTECTED]
To: Dan Tran [EMAIL PROTECTED]
Cc: MySQL List [EMAIL PROTECTED]
Sent: Monday, March 31, 2003 9:41 AM
Subject: Re: Case-Sensitive database
I'm not sure if you can do it globally... but here is what I do:
select passwd
from blerg
where login = Matt
I'm not sure if you can do it globally... but here is what I do:
select passwd
from blerg
where login = Matt
and binary login = Matt;
I do it twice b/c the binary operation is quite slow and doing the
normal equate first speeds it up significantly.
Doesn't exactly answer your
On 31 Mar 2003 at 9:49, Dan Tran wrote:
I wont work for me, I dont have access to SQL layer.
You can declare your columns as VARCHAR BINARY rather than VARCHAR in
your table creation. Another possibility might be to set your
character set for the database to latin1csas rather than the
PROTECTED]
Sent: Monday, March 31, 2003 10:13 AM
Subject: Re: Case-Sensitive database
On 31 Mar 2003 at 9:49, Dan Tran wrote:
I wont work for me, I dont have access to SQL layer.
You can declare your columns as VARCHAR BINARY rather than VARCHAR in
your table creation. Another possibility might
Hi,
I have a situation as follows:
There is a table that stores the user name.
One user name is 'David' and another is 'david'
I want to select only the user with the name
'david'(all small and not 'David')
MySQL is case insensitive in selecting records...
how to make it
On 15-Aug-2001 Järkeborn Joacim wrote:
Hi,
I have the table:
CREATE TABLE WI_TEXTLISTUS (
TEXTID VARCHAR(50) NOT NULL,
COUNTRY VARCHAR(2) NOT NULL,
LANGUAGEVARCHAR(3) NOT NULL,
TEXTVARCHAR(250),
PRIMARY KEY (TEXTID,COUNTRY,LANGUAGE),
If you add BINARY to the column it WILL make it case sensitive.
On Thursday 22 March 2001 22:01, you wrote:
Hello All,
I have a table with a column called "bus_name" varchar(100) which is used
in a Business Name search form. I need to make the Business Name that is
entered into the search
Try
Select * from table where upper(bus_name)= upper('whater I am searching
for');
Cal
http://www.calevans.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf
Of MikemickaloBlezien
Sent: Thursday, March 22, 2001 4:02 PM
To: [EMAIL PROTECTED]
Subject:
On Thu, 22 Mar 2001 22:27:06 +, Jordan Elver [EMAIL PROTECTED]
wrote:
Ignore this post! My fault, we had something coded wrong in the script.! It
works fine now.
My apologies to the list! :(
If you add BINARY to the column it WILL make it case sensitive.
On Thursday 22 March 2001 22:01,
On Thu, 22 Mar 2001 17:01:35 -0600, "Cal Evans" [EMAIL PROTECTED] wrote:
Thank Cal, I found the problem in our coding, not the query, so it works fine
now! My apologies to the list.
Appreciate the help :)
Try
Select * from table where upper(bus_name)= upper('whater I am searching
for');
A comparison will be case sensitivie, if any sub-part of the expression
is case sensitive. There are several ways to solve this:
1) CREATE or ALTER your tables so that the relevant CHAR and
VARCHAR fields are of type BINARY; change TEXTs to BLOBs
2) Use a case-sensitive, but neutral function
Ji Mikul wrote:
Hi all.
I have problem with MySQL 3.23.32 on FreeBSD4.2
SELECTs are not case sensitive, any suggestion how to set it ?
I'v looked into DOCs, but i'm not so clever from it :(( ...
my config options was only
./configure --prefix=/usr/local/mysql
Many thaks.
Jiri
24 matches
Mail list logo