Re: Case sensitivity

2014-05-21 Thread Johan De Meersman
- Original Message - From: Reindl Harald h.rei...@thelounge.net Subject: Re: Case sensitivity ALTER TABLE `my_table` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci; Purely from memory, doesn't that change the table but add the old setting to individual text columns? I

Re: Case sensitivity

2014-05-21 Thread Hartmut Holzgraefe
On 05/21/2014 08:14 AM, Johan De Meersman wrote: ALTER TABLE `my_table` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci; Purely from memory, doesn't that change the table but add the old setting to individual text columns? right, the above will only change the default for new

Re: Case sensitivity

2014-05-21 Thread Reindl Harald
Am 21.05.2014 10:50, schrieb Hartmut Holzgraefe: On 05/21/2014 08:14 AM, Johan De Meersman wrote: ALTER TABLE `my_table` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci; Purely from memory, doesn't that change the table but add the old setting to individual text columns? right,

Re: Case sensitivity

2014-05-21 Thread Larry Martell
On Wed, May 21, 2014 at 4:50 AM, Hartmut Holzgraefe hart...@skysql.com wrote: On 05/21/2014 08:14 AM, Johan De Meersman wrote: ALTER TABLE `my_table` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci; Purely from memory, doesn't that change the table but add the old setting to

Case sensitivity

2014-05-20 Thread Larry Martell
I have 2 servers, one is running 5.5.25a and the other 5.0.77. They both have the same collation and character set: mysql SELECT COLLATION(VERSION()); +--+ | COLLATION(VERSION()) | +--+ | utf8_general_ci | +--+ 1 row in set (0.00

Re: Case sensitivity

2014-05-20 Thread Reindl Harald
Am 20.05.2014 15:26, schrieb Larry Martell: I have 2 servers, one is running 5.5.25a and the other 5.0.77. They both have the same collation and character set: mysql SELECT COLLATION(VERSION()); +--+ | COLLATION(VERSION()) | +--+ |

Re: Case sensitivity

2014-05-20 Thread Hartmut Holzgraefe
On 05/20/2014 03:26 PM, Larry Martell wrote: Yet the 5.5.25a server is case sensitive as you would expect, but the 5.0.77 is not. How can I make the 5.0.77 server case sensitive? please provide the output of SHOW VARIABLES LIKE 'character_set_%'; and SHOW VARIABLES LIKE 'collation_%';

Re: Case sensitivity

2014-05-20 Thread Larry Martell
On Tue, May 20, 2014 at 9:38 AM, Hartmut Holzgraefe hart...@skysql.com wrote: On 05/20/2014 03:26 PM, Larry Martell wrote: Yet the 5.5.25a server is case sensitive as you would expect, but the 5.0.77 is not. How can I make the 5.0.77 server case sensitive? please provide the output of

Re: Case sensitivity

2014-05-20 Thread Hartmut Holzgraefe
On 05/20/2014 11:10 PM, Larry Martell wrote: 5.5 server: mysql select distinct(pnlCurrency) from PnLDetail; +-+ | pnlCurrency | +-+ | USD | | USd | +-+ 2 rows in set (0.00 sec) 5.0 server: mysql select distinct(pnlCurrency) from

Re: Case sensitivity

2014-05-20 Thread Larry Martell
On Tue, May 20, 2014 at 5:52 PM, Hartmut Holzgraefe hart...@skysql.com wrote: On 05/20/2014 11:10 PM, Larry Martell wrote: 5.5 server: mysql select distinct(pnlCurrency) from PnLDetail; +-+ | pnlCurrency | +-+ | USD | | USd | +-+ 2

Re: Case sensitivity

2014-05-20 Thread Reindl Harald
Am 21.05.2014 00:48, schrieb Larry Martell: ok, in this case the interesting piece of information would be the SHOW CREATE TABLE pnlCurrency; output from both. As the collation_database variables differ between the two servers (utf8_bin vs. latin1_swedish_ci) I assume that the same is the

Getting mySQL to ignore case sensitivity of field names

2009-08-27 Thread Adrian Aitken
Hi, Google isn't my friend :-( How can I tell mySQL 5.0 to ignore the case of field names i.e. FullName should also be able to be referenced as fullname,fullNAME etc ? I'm running it on a linux box at home but my copy at work (running on Windows 2000 server) has this by default - I certainly set

Re: Getting mySQL to ignore case sensitivity of field names

2009-08-27 Thread Scott Haneda
http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html You need to set the field format to a non binary one, and case insensitive will be the default. On Aug 27, 2009, at 2:57 PM, Adrian Aitken wrote: Hi, Google isn't my friend :-( How can I tell mySQL 5.0 to ignore the case of field

Re: Getting mySQL to ignore case sensitivity of field names

2009-08-27 Thread Adrian Aitken
Adrian - Original Message - From: Scott Haneda To: Adrian Aitken Cc: mysql@lists.mysql.com Sent: Thursday, August 27, 2009 11:04 PM Subject: Re: Getting mySQL to ignore case sensitivity of field names http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html You need to set the field

Re: Getting mySQL to ignore case sensitivity of field names

2009-08-27 Thread Scott Haneda
Oops, sorry about that. My understanding is this is OS dependent: http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html You may be able to set lowercase tables names, but would always have to use lowercase. I would just stick to entering in the correct case, as the other

Re: Getting mySQL to ignore case sensitivity of field names

2009-08-27 Thread Paul DuBois
. Can we see your query? Regards Adrian - Original Message - From: Scott Haneda To: Adrian Aitken Cc: mysql@lists.mysql.com Sent: Thursday, August 27, 2009 11:04 PM Subject: Re: Getting mySQL to ignore case sensitivity of field names http://dev.mysql.com/doc/refman/5.0/en/case

case sensitivity in stored procedure formal arguments

2007-02-28 Thread Lev Lvovsky
Could someone explain the logic of how case sensivity works on stored procedure formal argument names? Example: CREATE PROCEDURE sp_Test ( IN col1 INT, IN col2 INT ) BEGIN INSERT INTO Table SET COL1 = col1, COL2 = col2; END We've found that this is

Case sensitivity problem (I think) on OS X

2006-03-16 Thread Sterling Anderson
I'm running MySQL 5.0.18 on OS X 10.4.5, on an intel MacBook. My table definition is: CREATE TABLE `UNIT` ( `UNIT_ID` int(11) NOT NULL auto_increment, `UNIT_CODE` varchar(50) default NULL, `UNIT_DESC` varchar(50) default NULL, `USER_ID` int(11) NOT NULL, `USER_DT` datetime NOT NULL,

Re: Case sensitivity problem (I think) on OS X

2006-03-16 Thread Paul DuBois
At 15:22 -0600 3/16/06, Sterling Anderson wrote: I'm running MySQL 5.0.18 on OS X 10.4.5, on an intel MacBook. My table definition is: CREATE TABLE `UNIT` ( `UNIT_ID` int(11) NOT NULL auto_increment, `UNIT_CODE` varchar(50) default NULL, `UNIT_DESC` varchar(50) default NULL, `USER_ID`

Re: Case sensitivity problem (I think) on OS X

2006-03-16 Thread Sterling Anderson
On Mar 16, 2006, at 3:49 PM, Paul DuBois wrote: This fails however. 'g/dl' != 'g/dL' though. I don't get why a string field is being treated this way. I understand the HFS+ filesystem is not case sensitive but that shouldn't be an issued with varchar fields should it? No, it's not a

Re: Case sensitivity problem (I think) on OS X

2006-03-16 Thread Paul DuBois
At 16:01 -0600 3/16/06, Sterling Anderson wrote: On Mar 16, 2006, at 3:49 PM, Paul DuBois wrote: This fails however. 'g/dl' != 'g/dL' though. I don't get why a string field is being treated this way. I understand the HFS+ filesystem is not case sensitive but that shouldn't be an issued with

case sensitivity

2005-11-08 Thread Scott Hamm
I am running MySQL 5.0.15-nt on Windows 2000 PRO and use PHP as front-end for word search in Bible. My goal is to set an option for case sensitivity in text search. For example, if I want to search for the word Jehovah* I would expect Jehovah not JEHOVAH. This query works for my objective

Re: case sensitivity

2005-11-08 Thread Brent Baisley
:15 AM, Scott Hamm wrote: I am running MySQL 5.0.15-nt on Windows 2000 PRO and use PHP as front-end for word search in Bible. My goal is to set an option for case sensitivity in text search. For example, if I want to search for the word Jehovah* I would expect Jehovah not JEHOVAH. This query

Re: case sensitivity

2005-11-08 Thread Scott Hamm
am running MySQL 5.0.15-nt on Windows 2000 PRO and use PHP as front-end for word search in Bible. My goal is to set an option for case sensitivity in text search. For example, if I want to search for the word Jehovah* I would expect Jehovah not JEHOVAH. This query works for my objective

Forcing case sensitivity in queries

2004-09-04 Thread Yannick Warnier
Hi, When I execute a query in MySQL client, it seems like I cannot get the case-sensitivity to be activated. If I ask: SELECT * FROM mytable WHERE field = 'd'; I get all records containing 'd' or 'D'. How do I enable case-sensitivity? Thanks, Yannick -- MySQL General Mailing List For list

Re: Forcing case sensitivity in queries

2004-09-04 Thread Michael Stassen
You need BINARY http://dev.mysql.com/doc/mysql/en/Cast_Functions.html. SELECT * FROM mytable WHERE BINARY field = 'd'; Michael Yannick Warnier wrote: Hi, When I execute a query in MySQL client, it seems like I cannot get the case-sensitivity to be activated. If I ask: SELECT * FROM mytable WHERE

Re: Forcing case sensitivity in queries

2004-09-04 Thread Yannick Warnier
Le dim 05/09/2004 à 00:14, Yannick Warnier a écrit : Hi, When I execute a query in MySQL client, it seems like I cannot get the case-sensitivity to be activated. If I ask: SELECT * FROM mytable WHERE field = 'd'; I get all records containing 'd' or 'D'. How do I enable case

Table Name Case Sensitivity

2004-02-23 Thread Tim Hayes
Can anyone offer advice? I have come across a MySQL database on Linux with duplicate table names - Accounts and accounts. This seems fine on Linux, but does not transfer to the Windows environment - it is rejected because of the duplicate name. However I do see that Column Names have to be

Re: Table Name Case Sensitivity

2004-02-23 Thread Jochem van Dieten
Tim Hayes said: Can anyone offer advice? I have come across a MySQL database on Linux with duplicate table names - Accounts and accounts. This seems fine on Linux, but does not transfer to the Windows environment - it is rejected because of the duplicate name. However I do see that Column

Re: Table Name Case Sensitivity

2004-02-23 Thread Alec . Cawley
. There is no right answer to the question of case sensitivity. Mostly it will depend from which direction you approach the problem. As someone who uses both Windows and Linux, I can put on a different mental hat and get a different correct answer each time I approach the question. Anyway

Re: Table Name Case Sensitivity

2004-02-23 Thread Tim Hayes
- From: Peter Zaitsev [EMAIL PROTECTED] To: Tim Hayes [EMAIL PROTECTED] Sent: Monday, February 23, 2004 4:19 PM Subject: Re: Table Name Case Sensitivity On Mon, 2004-02-23 at 08:15, Tim Hayes wrote: Can anyone offer advice? Run with lower_case_table_names=1 I have come across

Re: Table Name Case Sensitivity

2004-02-23 Thread Heikki Tuuri
- Original Message - From: Peter Zaitsev [EMAIL PROTECTED] To: Tim Hayes [EMAIL PROTECTED] Sent: Monday, February 23, 2004 4:19 PM Subject: Re: Table Name Case Sensitivity On Mon, 2004-02-23 at 08:15, Tim Hayes wrote: Can anyone offer advice? Run with lower_case_table_names=1 I have come

Re: Table Name Case Sensitivity

2004-02-23 Thread Paul DuBois
At 16:56 + 2/23/04, Tim Hayes wrote: OK There is still the possibility of an in-compatability between the 2 platforms. However - in both Linux and Windows (MySQL 4.0.17) the variable is not recognized / updateable using the set command! Correct. You must set it using an option at server

Re: Table Name Case Sensitivity

2004-02-23 Thread Peter Zaitsev
On Mon, 2004-02-23 at 08:56, Tim Hayes wrote: OK There is still the possibility of an in-compatability between the 2 platforms. However - in both Linux and Windows (MySQL 4.0.17) the variable is not recognized / updateable using the set command! I get - Unknown system variable

case sensitivity of table names

2003-12-17 Thread Mayuran Yogarajah
I am using case sensitive table names when I create tables like : CREATE TABLE MyTest; If I want to do a select from this table, I have to do SELECT * FROM MyTest, not SELECT * FROM mytest. How can I make it so that the table name is still MyTest but selects work with mytest ? -- MySQL General

Re: case sensitivity of table names

2003-12-17 Thread Paul DuBois
At 12:22 -0500 12/17/03, Mayuran Yogarajah wrote: I am using case sensitive table names when I create tables like : CREATE TABLE MyTest; If I want to do a select from this table, I have to do SELECT * FROM MyTest, not SELECT * FROM mytest. How can I make it so that the table name is still MyTest

Re: case sensitivity of table names

2003-12-17 Thread Mayuran Yogarajah
Paul DuBois wrote: At 12:22 -0500 12/17/03, Mayuran Yogarajah wrote: I am using case sensitive table names when I create tables like : CREATE TABLE MyTest; If I want to do a select from this table, I have to do SELECT * FROM MyTest, not SELECT * FROM mytest. How can I make it so that the table

Re: case sensitivity of table names

2003-12-17 Thread Paul DuBois
At 13:00 -0500 12/17/03, Mayuran Yogarajah wrote: Paul DuBois wrote: At 12:22 -0500 12/17/03, Mayuran Yogarajah wrote: I am using case sensitive table names when I create tables like : CREATE TABLE MyTest; If I want to do a select from this table, I have to do SELECT * FROM MyTest, not SELECT *

case sensitivity in a delete query

2003-03-02 Thread Sunfire
hi i have a delete query that will delete a record based on the company name: delete from members where company='$company'; the query works fine and all but there is a problem because if there is more than 1 company listed but with different use of case in their name then allrecords that match

Re: case sensitivity in a delete query

2003-03-02 Thread Paul DuBois
At 17:51 -0500 3/2/03, Sunfire wrote: hi i have a delete query that will delete a record based on the company name: delete from members where company='$company'; the query works fine and all but there is a problem because if there is more than 1 company listed but with different use of case in

Case sensitivity

2002-12-19 Thread asp52
Hi, I have been searching tables based on search values which turn up tobe fine, however the results dont reflect case sensitivity. what i mean, if i run following query select field1 from table1 where name='text1'; this works fine but returns the same result set with text1 values of 'USER

RE: Case sensitivity

2002-12-19 Thread Mike Grabski
:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:06 AM To: [EMAIL PROTECTED] Subject: Case sensitivity Hi, I have been searching tables based on search values which turn up tobe fine, however the results dont reflect case sensitivity. what i mean, if i run following query select field1

Re: Case sensitivity

2002-12-19 Thread asp52
PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 2:29 PM Subject: RE: Case sensitivity You have two choices, you can use a binary datatype for the field, or force a binary comparison using the BINARY operator. http://www.mysql.com/doc/en/Case_Sensitivity_Operators.html http

Re: Case sensitivity

2002-12-19 Thread Alec . Cawley
searching tables based on search values which turn up tobe fine, however the results dont reflect case sensitivity. what i mean, if i run following query select field1 from table1 where name='text1'; this works fine but returns the same result set with text1 values of 'USER' or 'user'. i need to run

RE: Case sensitivity

2002-12-19 Thread Mike Grabski
You can specify a varchar field as binary, for instance: field1 varchar(50) binary query, sql Mike -Original Message- From: asp52 [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:50 AM To: Mike Grabski; [EMAIL PROTECTED] Subject: Re: Case sensitivity Thanks, Just worked

Case Sensitivity for CHECK TABLE TABLENAME??

2002-06-24 Thread Mark Weiler
Mac OS X mysql 3.23.47 I have a database with a table named: tname. After several inserts, I run CHECK TABLE tname; No errors are reported. I then run CHECK TABLE TNAME; And errors are reported! Which is it? Errors or no errors? Thanks Mark

Re: Case Sensitivity for CHECK TABLE TABLENAME??

2002-06-24 Thread Gerald R. Jensen
Mark: Do you have my.ini (or my.cfg) set to ignore case in table names? set-variable = lower_case_table_names=1 Gerald Jensen - Original Message - From: Mark Weiler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 5:56 PM Subject: Case Sensitivity for CHECK TABLE

case-sensitivity broken in FK clause for MySQL+InnoDB

2002-05-22 Thread ebekker
:Eugene Bekker Organization: organization of PR author (multiple lines) MySQL support: none Synopsis: case-sensitivity broken in FK clause for MySQL+InnoDB Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.50 (Official MySQL

Forcing case sensitivity via a query?

2002-05-22 Thread Richard Bolen
If I understand correctly, you have to define a char field as binary if you want the database to treat it as a 'case sensitive' field. Is there any way via a SQL query to force case sensitivity to be used for a non-binary char field? i.e.: for comparing strings in a case sensitive way

Re: Forcing case sensitivity via a query?

2002-05-22 Thread Luciano Barcaro
Hi Richard, Richard Bolen wrote: If I understand correctly, you have to define a char field as binary if you want the database to treat it as a 'case sensitive' field. Is there any way via a SQL query to force case sensitivity to be used for a non-binary char field? i.e.: for comparing

Re: case-sensitivity broken in FK clause for MySQL+InnoDB

2002-05-22 Thread Heikki Tuuri
the problem, if known (multiple lines) Submitter-Id: submitter ID Originator: Eugene Bekker Organization: organization of PR author (multiple lines) MySQL support: none Synopsis: case-sensitivity broken in FK clause for MySQL+InnoDB Severity: serious Priority: medium Category: mysql Class

Re: Forcing case sensitivity via a query?

2002-05-22 Thread Keith C. Ivey
On 22 May 2002, at 14:52, Richard Bolen wrote: Is there any way via a SQL query to force case sensitivity to be used for a non-binary char field? i.e.: for comparing strings in a case sensitive way. SELECT * FROM users WHERE BINARY password = 'cAsE_MAttErS'; http://www.mysql.com/doc/C

Re: MySQL unix vs WinXP case sensitivity

2002-04-04 Thread Miguel Angel Solorzano
At 11:03 3/4/2002 -0500, Eugene Mah wrote: Hi! Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-1999 Microsoft Corp. C:\c:\mysql\bin\mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version:

MySQL unix vs WinXP case sensitivity

2002-04-03 Thread Eugene Mah
I seem to be having issues with the way MySQL names the table files under Unix and WinXP. I'm not sure if it's a mysql issue or a windows issue. Normally, when I create tables in MySQL, I like to capitalize the first letter. Under unix, it all works fine and dandy. But under WinXP, the table

Re: Case sensitivity in Mysql

2002-03-14 Thread BD
At 02:05 AM 3/14/2002, you wrote: Hi, I run mysql on windows as well as linux. table creation and access right are given by java program. Problem im facing is., i create a table with name TEMP in windows in creates table with name temp and linux TEMP while giving rights thru GRANTstatement ,

Re: Case sensitivity in Mysql

2002-03-14 Thread Christopher Thompson
On Thursday 14 March 2002 9:32 am, BD wrote: Why or why couldn't MySQL have used case insensitive names in the first place? Store everything in lower case internally, but allow the user to use Invoice_Number or invoice_number or INVOICE_NUMBER in the SQL statement and it should refer to the

Re: Case sensitivity in Mysql

2002-03-14 Thread BD
At 11:17 AM 3/14/2002, you wrote: On Thursday 14 March 2002 9:32 am, BD wrote: Why or why couldn't MySQL have used case insensitive names in the first place? Store everything in lower case internally, but allow the user to use Invoice_Number or invoice_number or INVOICE_NUMBER in the SQL

Case sensitivity in Mysql

2002-03-13 Thread Ahmed S K Anis
Hi, I run mysql on windows as well as linux. table creation and access right are given by java program. Problem im facing is., i create a table with name TEMP in windows in creates table with name temp and linux TEMP while giving rights thru GRANTstatement , it fails in windows cause it expect

Re: Case Sensitivity Question

2002-02-18 Thread Benjamin Pflugmann
that the search is coming out case sensitive. According to the MySQL Docs all searches are done without case sensitivity. Well, not completely. The default is case insensitivity, but depending on the context, you get case sensitive comparisons. See also http://www.mysql.com/documentation/mysql/bychapter

Case Sensitivity Question

2002-02-17 Thread Mike Roest
are done without case sensitivity. I just have 2 questions: 1) I think the syntax I'm using is correct but incase it's not what is the correct syntax for a case insensitive search? 2) What version of MySQL did the default of case insensitive searches begin as I'm using 3.23.31. Thanks Mike What

Unique indexes and case sensitivity bug(?)

2002-02-13 Thread Andrea Forghieri
Submitter-Id: [EMAIL PROTECTED] Originator: root Organization: Emmegi S.p.A. (www.emmegi.it) MySQL support: [none ] Synopsis: Unique indexes and case sensitivity bug(?) Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.1-alpha (Official MySQL RPM) Server: /usr/bin

Fwd: Table names case sensitivity

2002-02-04 Thread Mr Kent Cheung
[EMAIL PROTECTED] Subject: Table names case sensitivity To: MySQL Discussion [EMAIL PROTECTED] Dear MySQL community, I am new MySQL user. I want to migrate a M$ SQL Server database to MySQL in a Linux box. Since table names in MySQL@Linux is case sensitive, I am having troubles connecting

RE: Table names case sensitivity

2002-01-31 Thread Mr Kent Cheung
Neil, Thank you for your suggestion. Unfortunately, the Grant command grants privileges to lower case table names also. I have also tried to find solution from archive of mysql mail lists but nothing useful have been found. Kent. --- Neil Silvester [EMAIL PROTECTED] wrote: -Original

Table names case sensitivity

2002-01-31 Thread Egor Egorov
from a Windows box. MKC I search the documentation and find that I may be able MKC to disable the case sensitivity by setting the MKC variable called lower_case_table_names to 1 when MKC starting the server. I edit my.cnf and restart the MKC server. Everything seems OK. mysqladmin and the Show MKC

Fwd: Table names case sensitivity

2002-01-31 Thread Mr Kent Cheung
12:12:01 +0200 To: [EMAIL PROTECTED] From: Egor Egorov [EMAIL PROTECTED] Subject: Table names case sensitivity Mr, Thursday, January 31, 2002, 6:01:21 AM, you wrote: MKC Dear MySQL community, MKC I am new MySQL user. I want to migrate a M$ SQL Server MKC database to MySQL in a Linux

Fwd: Table names case sensitivity

2002-01-31 Thread Egor Egorov
on database.Company instead of database.company You should update permissions for you. MKC Thanks for your suggestion anyway. MKC Kent. [skip] MKC I search the documentation and find that I may be able MKC to disable the case sensitivity by setting the MKC variable called lower_case_table_names to 1 when

Table names case sensitivity

2002-01-30 Thread Mr Kent Cheung
to disable the case sensitivity by setting the variable called lower_case_table_names to 1 when starting the server. I edit my.cnf and restart the server. Everything seems OK. mysqladmin and the Show Variables command in mysql confirm that this variable is now 1 instead of 0 before I make the changes

Disable case sensitivity

2002-01-10 Thread Fernando Monteiro Duarte
Hi, Does anybody knows if is possible to disable case sensitivity in Linux MySQL?? Thanks in advance, Fernando Monteiro Duarte - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: Disable case sensitivity

2002-01-10 Thread Jeremy Zawodny
On Thu, Jan 10, 2002 at 11:52:34AM -0300, Fernando Monteiro Duarte wrote: Hi, Does anybody knows if is possible to disable case sensitivity in Linux MySQL?? Case sensitivity in what part? Table names? Values in columns? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo

Re: Disable case sensitivity

2002-01-10 Thread Fernando Monteiro Duarte
PROTECTED] Sent: Thursday, January 10, 2002 12:06 PM Subject: Re: Disable case sensitivity On Thu, Jan 10, 2002 at 11:52:34AM -0300, Fernando Monteiro Duarte wrote: Hi, Does anybody knows if is possible to disable case sensitivity in Linux MySQL?? Case sensitivity in what part

RE: Disable case sensitivity

2002-01-10 Thread Ho, Kam
Jerry: Can you specify the hardware/software your MySQL 3.23.41-max is running on? Kam -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 9:07 AM To: Fernando Monteiro Duarte Cc: [EMAIL PROTECTED] Subject: Re: Disable case sensitivity

Re: Disable case sensitivity

2002-01-10 Thread Sinisa Milivojevic
Fernando Monteiro Duarte writes: Hi Mr. Zawodny, If is possible, in everything from a Database, but if is not, in columns is more important. Thanks in advance, Fernando Monteiro Duarte Hi! Column names are case insensitive. -- Regards, __ ___ ___ __ /

Re: Disable case sensitivity

2002-01-10 Thread Jeremy Zawodny
On Thu, Jan 10, 2002 at 09:14:51AM -0500, Ho, Kam wrote: Can you specify the hardware/software your MySQL 3.23.41-max is running on? That machine is a dual-CPU Linux 2.4.9 box with 2GB of RAM and 4 36GB ultra-wide SCSI drives for the data and replication logs. Before the restart we did in

Re: Disable case sensitivity

2002-01-10 Thread Fernando Monteiro Duarte
But how about the fields, the content of a database ?? Fernando - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 12:32 PM Subject: Re: Disable case sensitivity Fernando Monteiro

RE: Disable case sensitivity

2002-01-10 Thread Nally, Tyler G.
-Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Subject: Re: Disable case sensitivity If is possible, in everything from a Database, but if is not, in columns is more important. Column names are case insensitive. Correct... Database names and Table

Re: Disable case sensitivity

2002-01-10 Thread Jeremy Zawodny
On Thu, Jan 10, 2002 at 12:58:03PM -0200, Fernando Monteiro Duarte wrote: But how about the fields, the content of a database ?? VARCHAR and CHAR fields are not case-sensitive unless you declare them with the BINARY attribute. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo -

RE: Disable case sensitivity

2002-01-10 Thread Roger Baklund
* Fernando Monteiro Duarte But how about the fields, the content of a database ?? char and varchar are by default not case sensitive, but can be made case sensitive using the BINARY operator... URL: http://www.mysql.com/doc/C/a/Case_Sensitivity_Operators.html -- Roger

Re: Disable case sensitivity

2002-01-10 Thread Thibaut Allender
At 16:22 10/01/2002, you wrote: On Thu, Jan 10, 2002 at 12:58:03PM -0200, Fernando Monteiro Duarte wrote: But how about the fields, the content of a database ?? VARCHAR and CHAR fields are not case-sensitive unless you declare them with the BINARY attribute. neither TEXT/LONGTEXT --

Case Sensitivity in MySQL

2001-12-26 Thread SankaraNarayanan Mahadevan
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 case-sensitive in

MySQL table name case sensitivity

2001-11-29 Thread Michael Collins
Since Mac OS X is Unix it should use the same rules as a Unix machine when it comes to MySQL and case sensitivity of table and database names. According to Dubois: DB and tables in MySQL correspond to directories and files in the underlying file system on the server host. As a result, case

case sensitivity issue

2001-08-15 Thread Alex Pukinskis
I'm having trouble with what appears to be a case sensitivity issue. Essentially, when I use the right case for a table name, the query fails, but when I use the wrong case, the query succeeds. Here's my table list: mysql show tables\g ++ | Tables_in_ac

Re: case sensitivity issue

2001-08-15 Thread Werner Stürenburg
I'm having trouble with what appears to be a case sensitivity issue. Essentially, when I use the right case for a table name, the query fails, but when I use the wrong case, the query succeeds. Well, it seems to depend on the system you are using. I noticed that when I created tables through

Case Sensitivity Problem

2001-03-09 Thread Kif Henderson
Hi, Can somebody PLEASE help me If I send a query to get a list of names, like this: SELECT Name FROM users ORDER BY Name, I get a list of users like this... Bob Jon Mark Sally andy lucy mary steve when what I REALLY want is this... andy Bob Jon lucy Mark mary Sally Steve Can someone

RE: Case Sensitivity Problem

2001-03-09 Thread Cal Evans
Select Name, lower(name) as sortOrder from users order by sortOrder; Not exactly what you wanted, but closer. Cal http://www.calevans.com -Original Message- From: Kif Henderson [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 7:38 PM To: [EMAIL PROTECTED] Subject: Case