Hello Ananda,
On 5/16/2012 6:42 AM, Ananda Kumar wrote:
why are not using any where condition in the update statment
WHERE clauses are not required. Performing a command without one will
affect ever row on the table.
On Wed, May 16, 2012 at 1:24 PM, GF wrote:
Good morning,
I have an ap
What language(s) are involved? What collation are you using now?
The German sharp-S does not work well with case folding.
utf8_unicode_ci could have stuff folding together.
Etc.
If you can find a USER_ID that is causing trouble, please provide
SELECT HEX(USER_ID) FROM ... WHERE ...
for further
why are not using any where condition in the update statment
On Wed, May 16, 2012 at 1:24 PM, GF wrote:
> Good morning,
> I have an application where the user ids were stored lowercase.
> Some batch import, in the user table some users stored a uppercase
> id, and for some applicative logic, in
Good morning,
I have an application where the user ids were stored lowercase.
Some batch import, in the user table some users stored a uppercase
id, and for some applicative logic, in other tables that have a
foreign key to the user table, their user ids are stored lowercase.
MySQL didn't throw an