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
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
On 12/3/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
>
> Hello.
>
>
>
> Check if you're able to start server manually using mysqld
>
> or mysqld_safe commands. Research error logs. See:
>
> http://dev.mysql.com/doc/refman/5.0/en/starting-server.html
>
>
>
>
>
Thanks. Running mysqld directly show
Hi,
I'm on Debian system. I tried to modify /etc/mysql/debian-log-rotate to set
KEEP-BINARY-LOGS from 0 to 5. After doing so I attempted to let the change
register by stopping and restarting the server by running /etc/init.d/mysql
stop. However this command hanged. I rebooted the system and but t
Hi,
While I was trying to index a field on an already existing table, my
partition became full. Checking into mysql database I realized the
repository (if it is so called?!) for the database files (frm, myd, and myi)
were located at /var/lib/mysql/diginorth/. I found three files started with
pound
