[Phpmyadmin-devel] Regarding ticket #946 Warn before changing collations
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
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
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
On Mar 7, 2015, at 7:22 AM, Marc Delisle <marc@infomarc.info> wrote:
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/
Thanks Marc!
-- Marc Delisle | phpMyAdmin
------------------------------------------------------------------------------ Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
i have a problem while i am trying to open the php files in the phpmyadmin repo present at github it is asking for an user id and password for connecting to phpmyadmin. what should i do?
i am trying to open them in my browser thru xamp. On Thu, Mar 12, 2015 at 11:28 PM, Arindam Padhy <b113007@iiit-bh.ac.in> wrote:
i have a problem while i am trying to open the php files in the phpmyadmin repo present at github it is asking for an user id and password for connecting to phpmyadmin. what should i do?
Arindam Padhy a écrit :
i have a problem while i am trying to open the php files in the phpmyadmin repo present at github it is asking for an user id and password for connecting to phpmyadmin. what should i do?
Hi, this is not a support mailing list. For support, visit http://phpmyadmin.net and click on Support. -- Marc Delisle (phpMyAdmin)
participants (4)
-
Arindam Padhy -
Isaac Bennetch -
Marc Delisle -
Pranav Sharma