Hello Folks,
I would like to have MySQL differentiate between 'abc'
and 'ABC' both the server and clients. so far anything
I've done has not worked.
when I defined the database it was using the
latin1_swedish_ci Collation, now I have issued the
alter database COLLATE to use latin1_bin one, droped a
table and re-loaded it, so far so good, same issue.
help would be appreciated.
regards,
esv.
here is my /etc/my.cnf
===========================
[mysql.server]
basedir=/opt/freeware/mysql
datadir=/esv/MYSQL
pid-file=/esv/MYSQL/xxxx.pid
log-error=/esv/MYSQL/error.log
character_set_server=latin1
collation_server=latin1_bin
character-sets-dir=/usr/local/mysql/share/mysql/charsets
[client]
user=xxxxx
password=xxxxxx
default-character-set=latin1
character-sets-dir=/usr/local/mysql/share/mysql/charsets
[mysqld]
log-error=/esv/MYSQL/error.log
#default-character-set=latin1
#default-collation=latin1_bin
character_set_server=latin1
collation_server=latin1_bin
character-sets-dir=/usr/local/mysql/share/mysql/charsets
[mysqld_safe]
log-error=/esv/MYSQL/error.log
character_set_client=latin1
character_set_server=latin1
collation_server=latin1_bin
character-sets-dir=/usr/local/mysql/share/mysql/charsets
======================================
Enrique Sanchez Vela
email: [EMAIL PROTECTED]
-----------------------------------------------------------------------------
It's often easier to fight for one's || We live in the outer space
principles than to live up to them || Rev. Kay Greenleaf
Adlai Stevenson ||
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
