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? Table names? Values in columns? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 189,274,654 queries (287/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Disable case sensitivity
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 - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Fernando Monteiro Duarte [EMAIL PROTECTED] Cc: [EMAIL 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? Table names? Values in columns? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 189,274,654 queries (287/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Disable case sensitivity
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 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 Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 189,274,654 queries (287/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Disable case sensitivity
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, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Disable case sensitivity
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 December, it was approaching 2 billion queries since the time before. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 190,083,461 queries (288/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Disable case sensitivity
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 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, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Disable case sensitivity
-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 names don't necessarily share this (according to the MySQL manual snippet below). 6.1.3 Case Sensitivity in Names In MySQL, databases and tables correspond to directories and files within those directories. Consequently, the case sensitivity of the underlying operating system determines the case sensitivity of database and table names. This means database and table names are case sensitive in Unix and case insensitive in Windows. See section 1.7.3 MySQL Extensions to ANSI SQL92. NOTE: Although database and table names are case insensitive for Windows, you should not refer to a given database or table using different cases within the same query. The following query would not work because it refers to a table both as my_table and as MY_TABLE: SELECT * FROM my_table WHERE MY_TABLE.col=1; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Disable case sensitivity
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 - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 191,007,477 queries (288/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Disable case sensitivity
* 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Disable case sensitivity
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 -- .thibaut allender ~ dev:network. @ magic:sq. .tel. : +32 2 / 209 83 71 ~ http://magicsquare.be - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php