[Phpmyadmin-devel] Regarding ticket #946 Warn before changing collations

[Marc Delisle]

Le 2015-03-06 18:19, Isaac Bennetch a écrit :
> 
> 
> On 3/6/15 4:29 PM, Pranav Sharma wrote:
>> Hi phpmyadmin,
>> I am an aspiring gsoc participant. I have already devised solutions
>> regarding Feature Request Project Enhancements. However to fully
>> understand some of them, I will need to recreate the present scenarios
>> of some of the Feature Requests. For instance, Can i be given a use-case
>> where changing collation changes the data? I have tried creating my own
>> table and changing the column collations only to find my data intact. If
>> you could present to me a step wise use-case, then i could better
>> understand the problem and write a solution strategy.
>> Thanks,
>> Pranav
> 
> Hello Pranav, and thanks for your interest. I'm not sure whether this
> problem exists anymore; I just tried to recreate it and I also don't
> experience any corruption of my data.
> 
> It sounds like you've done it correctly; the steps to reproduce used to
> be creating a column with a particular collation, inserting text, and
> then changing the collation for that column, causing the data to
> seemingly change. As Marc noted in the tracker, it only applies when
> changing the actual column, not database or table collations. Anyway, at
> this point I can't reproduce it and may need to close the ticket
> depending on any further input from the other developers.
> 
> Thanks
> ~isaac
> 

This is still problematic; I added an example in
https://sourceforge.net/p/phpmyadmin/feature-requests/946/

-- 
Marc Delisle | phpMyAdmin