and the follow-up
witango is case insensitive. seems that mysql is also case insensitive.
How do I set a look-up that is case sensitive? So that password is not
the same as ?
TO UNSUBSCRIBE: Go to
@IF @CIPHER action=hash type=md5 str=db_password = @CIPHER action=hash
type=md5 str=arg_password
-Original Message-
From: Roland Dumas [mailto:radu...@mac.com]
Sent: Tuesday, April 20, 2010 2:09 PM
To: witango-talk@witango.com
Subject: Witango-Talk: case matching
and the follow-up
]
Sent: Tuesday, April 20, 2010 2:09 PM
To: witango-talk@witango.com
Subject: Witango-Talk: case matching
and the follow-up
witango is case insensitive. seems that mysql is also case insensitive.
How do I set a look-up that is case sensitive? So that password is not
the same
do
MD5(password_column) as a custom search criteria column.
Since I use Witango 5.5 and MS SQL primarily, YMMV
Robert
-Original Message-
From: Roland Dumas [mailto:radu...@mac.com]
Sent: Tuesday, April 20, 2010 2:19 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: case matching
To: witango-talk@witango.com
Subject: Witango-Talk: case matching
and the follow-up
witango is case insensitive. seems that mysql is also case insensitive.
How do I set a look-up that is case sensitive? So that password is not
the same as
MySQL is not case insensitive. MySQL can EITHER be case sensitive, or case
insensitive.
When you setup a database, or table, or even at the column level, there is a
COLLATION option. So if you are using encoding of UTF8, then you are probably
using collation of utf8_general_ci. That ci on the
...@mac.com]
Sent: Tuesday, April 20, 2010 2:19 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: case matching
@cipher in witango 5.0?
if so, can this be done in the search action?
On Apr 20, 2010, at 11:14 AM, Robert Shubert wrote:
@IF @CIPHER action=hash type=md5 str
hmm, playing with this. For UTF8, the collation options are utf8_bin and then a
series of language specific _ci options.
for ascii, there are choices of ascii_bin and ascii_general_ci
etc.
On Apr 20, 2010, at 12:32 PM, Robert Garcia wrote:
MySQL is not case insensitive. MySQL can EITHER be
ok, I see. If I set char set at ascii and collation at ascii_bin, then the
match becomes case sensitive. Simplest solution. thank you, again.
On Apr 20, 2010, at 12:32 PM, Robert Garcia wrote:
MySQL is not case insensitive. MySQL can EITHER be case sensitive, or case
insensitive.
When
utf8_bin, is case sensitive. You want to use utf8_general or utf8_general_ci
for mostly text fields.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
15520 Coutelenc Rd
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
rgar...@bighead.net -
10 matches
Mail list logo