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

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... http://www.mysql.com/doc/C/a/Case_Sensitivity_Operators.html > -- Roger

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 Yaho

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 insensitiv

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 c

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 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 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 Fernando Monteiro Duarte
ot; <[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 possibl

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 -