Hi,
First of all, thanks for accepting my proposal. I am very delighted that I got a chance to take part in Great Google Summer of Code Program and phpMyAdmin was my favorite choice. I posted my proposal to my blog. http://www.imblog.info/export-relations-schema-project-google-summer-of-code-2010
I expect to get the feedback about my proposal from the Community :) Thanks!
I will write weekly status reports at my blog and will regularly tweet my progress.
My twitter: @hiddenpearls
Regards Muhammad Adnan
Hi
Dne Thu, 29 Apr 2010 00:38:15 +0500 ADnan hiddenpearls@gmail.com napsal(a):
First of all, thanks for accepting my proposal. I am very delighted that I got a chance to take part in Great Google Summer of Code Program and phpMyAdmin was my favorite choice. I posted my proposal to my blog. http://www.imblog.info/export-relations-schema-project-google-summer-of-code-2010
Welcome and looking forward to cooperation with you.
Hi
Dne Thu, 29 Apr 2010 00:38:15 +0500 ADnan hiddenpearls@gmail.com napsal(a):
First of all, thanks for accepting my proposal. I am very delighted that I got a chance to take part in Great Google Summer of Code Program and phpMyAdmin was my favorite choice. I posted my proposal to my blog. http://www.imblog.info/export-relations-schema-project-google-summer-of-code-2010
Your website seems to be down all the day and returns just "Default Website Page"...
On Thu, May 6, 2010 at 4:27 PM, Michal Čihař michal@cihar.com wrote:
Hi
Dne Thu, 29 Apr 2010 00:38:15 +0500 ADnan hiddenpearls@gmail.com napsal(a):
First of all, thanks for accepting my proposal. I am very delighted that
I
got a chance to take part in Great Google Summer of Code Program and phpMyAdmin was my favorite choice. I posted my proposal to my blog. <
http://www.imblog.info/export-relations-schema-project-google-summer-of-code...
Your website seems to be down all the day and returns just "Default Website Page"...
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Really ? I am using uptimerobot service who emails me when the server is down. how I can test it ? do u know any other way ?
It is paid hosting :(
Hi
Dne Thu, 6 May 2010 16:31:10 +0500 ADnan hiddenpearls@gmail.com napsal(a):
Really ? I am using uptimerobot service who emails me when the server is down. how I can test it ? do u know any other way ?
The server is up, just your content is not there ;-).
On Thu, May 6, 2010 at 4:44 PM, Michal Čihař michal@cihar.com wrote:
Hi
Dne Thu, 6 May 2010 16:31:10 +0500 ADnan hiddenpearls@gmail.com napsal(a):
Really ? I am using uptimerobot service who emails me when the server is down. how I can test it ? do u know any other way ?
The server is up, just your content is not there ;-).
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
pretty strange ,, can u please send me screen shot ? also which hosting you are using for your blog ? or you think is better hosting provider ?
Dne Thu, 6 May 2010 18:01:38 +0500 ADnan hiddenpearls@gmail.com napsal(a):
pretty strange ,, can u please send me screen shot ?
Okay, looking a bit deeper into the problem and the issue is DNS of your hosting.
They have two DNS servers:
imblog.info. 86400 IN NS ns1.puzzlehosting.com. imblog.info. 86400 IN NS ns2.puzzlehosting.com.
But each of them returns different address:
$ nslookup www.imblog.info ns2.puzzlehosting.com Server: ns2.puzzlehosting.com Address: 195.191.25.158#53
www.imblog.info canonical name = imblog.info. Name: imblog.info Address: 195.191.24.153
$ nslookup www.imblog.info ns1.puzzlehosting.com Server: ns1.puzzlehosting.com Address: 208.116.16.18#53
www.imblog.info canonical name = imblog.info. Name: imblog.info Address: 195.191.24.158
The 195.191.24.153 works fine, while 195.191.24.158 does not.
Screenshot is here: http://tmp.cihar.com/imblog.info.png
also which hosting you are using for your blog ? or you think is better hosting provider ?
I have own server what is probably not a solution for you.
Michal Čihař a écrit :
Dne Thu, 6 May 2010 18:01:38 +0500 ADnan hiddenpearls@gmail.com napsal(a):
pretty strange ,, can u please send me screen shot ?
Okay, looking a bit deeper into the problem and the issue is DNS of your hosting.
They have two DNS servers:
imblog.info. 86400 IN NS ns1.puzzlehosting.com. imblog.info. 86400 IN NS ns2.puzzlehosting.com.
But each of them returns different address:
$ nslookup www.imblog.info ns2.puzzlehosting.com Server: ns2.puzzlehosting.com Address: 195.191.25.158#53
www.imblog.info canonical name = imblog.info. Name: imblog.info Address: 195.191.24.153
$ nslookup www.imblog.info ns1.puzzlehosting.com Server: ns1.puzzlehosting.com Address: 208.116.16.18#53
www.imblog.info canonical name = imblog.info. Name: imblog.info Address: 195.191.24.158
The 195.191.24.153 works fine, while 195.191.24.158 does not.
Both name servers queried from here currently return 195.191.24.158.
Dne Thu, 06 May 2010 10:43:27 -0400 Marc Delisle marc@infomarc.info napsal(a):
Both name servers queried from here currently return 195.191.24.158.
Same here now. What means that the web does not work...
Michal Čihař a écrit :
Dne Thu, 06 May 2010 10:43:27 -0400 Marc Delisle marc@infomarc.info napsal(a):
Both name servers queried from here currently return 195.191.24.158.
Same here now. What means that the web does not work...
I confirm that http://www.imblog.info currently shows a default website page.
2010/5/6 Marc Delisle marc@infomarc.info:
Michal Čihař a écrit :
Dne Thu, 6 May 2010 18:01:38 +0500 ADnan hiddenpearls@gmail.com napsal(a):
But each of them returns different address:
$ nslookup www.imblog.info ns2.puzzlehosting.com Server: ns2.puzzlehosting.com Address: 195.191.25.158#53
www.imblog.info canonical name = imblog.info. Name: imblog.info Address: 195.191.24.153
The 195.191.24.153 works fine, while 195.191.24.158 does not.
Both name servers queried from here currently return 195.191.24.158.
Same here, but IP-address of ns2.puzzlehosting.com is 208.116.16.19 in my case.
Maybe this has something to do with this : http://tech.slashdot.org/story/10/04/30/1258234/DNSSEC-May-Cause-Problems-On...
On Thu, May 6, 2010 at 10:45 PM, Dieter Adriaenssens < dieter.adriaenssens@gmail.com> wrote:
2010/5/6 Marc Delisle marc@infomarc.info:
Michal Čihař a écrit :
Dne Thu, 6 May 2010 18:01:38 +0500 ADnan hiddenpearls@gmail.com napsal(a):
But each of them returns different address:
$ nslookup www.imblog.info ns2.puzzlehosting.com Server: ns2.puzzlehosting.com Address: 195.191.25.158#53
www.imblog.info canonical name = imblog.info. Name: imblog.info Address: 195.191.24.153
The 195.191.24.153 works fine, while 195.191.24.158 does not.
Both name servers queried from here currently return 195.191.24.158.
Same here, but IP-address of ns2.puzzlehosting.com is 208.116.16.19 in my case.
Maybe this has something to do with this :
http://tech.slashdot.org/story/10/04/30/1258234/DNSSEC-May-Cause-Problems-On...
-- Greets,
Dieter Adriaenssens
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
You guys were right, there seems some problem. I will check it right now ..
It seems some serious problems with my existing hosting. So, I bought a new one now. I will host my blog now on it in next couple of days.
On Thu, May 6, 2010 at 11:03 PM, ADnan hiddenpearls@gmail.com wrote:
On Thu, May 6, 2010 at 10:45 PM, Dieter Adriaenssens < dieter.adriaenssens@gmail.com> wrote:
2010/5/6 Marc Delisle marc@infomarc.info:
Michal Čihař a écrit :
Dne Thu, 6 May 2010 18:01:38 +0500 ADnan hiddenpearls@gmail.com napsal(a):
But each of them returns different address:
$ nslookup www.imblog.info ns2.puzzlehosting.com Server: ns2.puzzlehosting.com Address: 195.191.25.158#53
www.imblog.info canonical name = imblog.info. Name: imblog.info Address: 195.191.24.153
The 195.191.24.153 works fine, while 195.191.24.158 does not.
Both name servers queried from here currently return 195.191.24.158.
Same here, but IP-address of ns2.puzzlehosting.com is 208.116.16.19 in my case.
Maybe this has something to do with this :
http://tech.slashdot.org/story/10/04/30/1258234/DNSSEC-May-Cause-Problems-On...
-- Greets,
Dieter Adriaenssens
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
You guys were right, there seems some problem. I will check it right now ..
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
hi, my blog is up and I am ready to start working on project. I have started coding from today. Git repo is also up and its link is http://repo.or.cz/w/phpmyadmin/adnan.git
I'm working on the base class and sub classes structure. I need to take suggestion from you that how I should move forward ?
We should give this exporting feature under the operations tab ? or a separate tab ?
On Mon, May 10, 2010 at 12:55 PM, ADnan hiddenpearls@gmail.com wrote:
It seems some serious problems with my existing hosting. So, I bought a new one now. I will host my blog now on it in next couple of days.
On Thu, May 6, 2010 at 11:03 PM, ADnan hiddenpearls@gmail.com wrote:
On Thu, May 6, 2010 at 10:45 PM, Dieter Adriaenssens < dieter.adriaenssens@gmail.com> wrote:
2010/5/6 Marc Delisle marc@infomarc.info:
Michal Čihař a écrit :
Dne Thu, 6 May 2010 18:01:38 +0500 ADnan hiddenpearls@gmail.com napsal(a):
But each of them returns different address:
$ nslookup www.imblog.info ns2.puzzlehosting.com Server: ns2.puzzlehosting.com Address: 195.191.25.158#53
www.imblog.info canonical name = imblog.info. Name: imblog.info Address: 195.191.24.153
The 195.191.24.153 works fine, while 195.191.24.158 does not.
Both name servers queried from here currently return 195.191.24.158.
Same here, but IP-address of ns2.puzzlehosting.com is 208.116.16.19 in my case.
Maybe this has something to do with this :
http://tech.slashdot.org/story/10/04/30/1258234/DNSSEC-May-Cause-Problems-On...
-- Greets,
Dieter Adriaenssens
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
You guys were right, there seems some problem. I will check it right now ..
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
Dne Mon, 24 May 2010 18:44:04 +0500 ADnan hiddenpearls@gmail.com napsal(a):
hi, my blog is up and I am ready to start working on project. I have started coding from today. Git repo is also up and its link is http://repo.or.cz/w/phpmyadmin/adnan.git
I'm working on the base class and sub classes structure. I need to take suggestion from you that how I should move forward ?
We should give this exporting feature under the operations tab ? or a separate tab ?
It should be part of the operations tab and should use same interface as PDF relations (I'm not saying that this interface can not be changed, because I think it should, but all formats should share same interface).
hi,
first week ended and here is my status report: http://www.imblog.info/summer-of-code-first-week-ended
On Mon, May 24, 2010 at 8:03 PM, Michal Čihař michal@cihar.com wrote:
Dne Mon, 24 May 2010 18:44:04 +0500 ADnan hiddenpearls@gmail.com napsal(a):
hi, my blog is up and I am ready to start working on project. I have
started
coding from today. Git repo is also up and its link is http://repo.or.cz/w/phpmyadmin/adnan.git
I'm working on the base class and sub classes structure. I need to take suggestion from you that how I should move forward ?
We should give this exporting feature under the operations tab ? or a separate tab ?
It should be part of the operations tab and should use same interface as PDF relations (I'm not saying that this interface can not be changed, because I think it should, but all formats should share same interface).
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
My status report for 2nd week ! http://www.imblog.info/google-summer-of-code-2010-2nd-week
On Fri, May 28, 2010 at 11:06 PM, ADnan hiddenpearls@gmail.com wrote:
hi,
first week ended and here is my status report: http://www.imblog.info/summer-of-code-first-week-ended
On Mon, May 24, 2010 at 8:03 PM, Michal Čihař michal@cihar.com wrote:
Dne Mon, 24 May 2010 18:44:04 +0500 ADnan hiddenpearls@gmail.com napsal(a):
hi, my blog is up and I am ready to start working on project. I have
started
coding from today. Git repo is also up and its link is http://repo.or.cz/w/phpmyadmin/adnan.git
I'm working on the base class and sub classes structure. I need to take suggestion from you that how I should move forward ?
We should give this exporting feature under the operations tab ? or a separate tab ?
It should be part of the operations tab and should use same interface as PDF relations (I'm not saying that this interface can not be changed, because I think it should, but all formats should share same interface).
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
hi Cihar,
1. I am thinking to code a config class in which I define all the Global vars that are used in Schema Export ?? It will be better instead of using Global Vars in methods. what do u think ?
Class name will be PMA_SCHEMA_config ..
2. I noticed in PDF Relation Export classes .. There is a function name PMA_RT_DOC should be renamed to PMA_RT_dataDictionary
On Sat, Jun 5, 2010 at 6:04 AM, ADnan hiddenpearls@gmail.com wrote:
My status report for 2nd week ! http://www.imblog.info/google-summer-of-code-2010-2nd-week
On Fri, May 28, 2010 at 11:06 PM, ADnan hiddenpearls@gmail.com wrote:
hi,
first week ended and here is my status report: http://www.imblog.info/summer-of-code-first-week-ended
On Mon, May 24, 2010 at 8:03 PM, Michal Čihař michal@cihar.com wrote:
Dne Mon, 24 May 2010 18:44:04 +0500 ADnan hiddenpearls@gmail.com napsal(a):
hi, my blog is up and I am ready to start working on project. I have
started
coding from today. Git repo is also up and its link is http://repo.or.cz/w/phpmyadmin/adnan.git
I'm working on the base class and sub classes structure. I need to take suggestion from you that how I should move forward ?
We should give this exporting feature under the operations tab ? or a separate tab ?
It should be part of the operations tab and should use same interface as PDF relations (I'm not saying that this interface can not be changed, because I think it should, but all formats should share same interface).
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
Hi
Dne Tue, 22 Jun 2010 17:55:11 +0500 ADnan hiddenpearls@gmail.com napsal(a):
- I am thinking to code a config class in which I define all the Global
vars that are used in Schema Export ?? It will be better instead of using Global Vars in methods. what do u think ?
Class name will be PMA_SCHEMA_config ..
Why you need separate class for configuration? Shouldn't that be part of either PMA_Config (if it is some global settings) or PMA_Schema (if it is schema specific).
You don't need any global variables for both, just use method attributes for this.
hi,
I am working with XMLWriter Extension for generating XML Documents for SVG,DIA,VISIO formats for generating schema .. but I noticed in XMLWriter .. this extension just provides utf-8 encoding ..
Experts & Mentors, Please suggest what should I do ??
though, I am going to digg more in that issue to see any solution for this ...
On Tue, Jun 22, 2010 at 7:09 PM, Michal Čihař michal@cihar.com wrote:
Hi
Dne Tue, 22 Jun 2010 17:55:11 +0500 ADnan hiddenpearls@gmail.com napsal(a):
- I am thinking to code a config class in which I define all the Global
vars that are used in Schema Export ?? It will be better instead of using Global Vars in methods. what do u think ?
Class name will be PMA_SCHEMA_config ..
Why you need separate class for configuration? Shouldn't that be part of either PMA_Config (if it is some global settings) or PMA_Schema (if it is schema specific).
You don't need any global variables for both, just use method attributes for this.
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
ADnan a écrit :
hi,
I am working with XMLWriter Extension for generating XML Documents for SVG,DIA,VISIO formats for generating schema .. but I noticed in XMLWriter .. this extension just provides utf-8 encoding ..
I don't know much about this subject but please explain why generating in utf-8 encoding is a problem.
Experts & Mentors, Please suggest what should I do ??
though, I am going to digg more in that issue to see any solution for this ...
On Tue, Jun 22, 2010 at 11:55 PM, Marc Delisle marc@infomarc.info wrote:
ADnan a écrit :
hi,
I am working with XMLWriter Extension for generating XML Documents for SVG,DIA,VISIO formats for generating schema .. but I noticed in XMLWriter .. this extension just provides utf-8 encoding ..
I don't know much about this subject but please explain why generating in utf-8 encoding is a problem.
This issue is making me think that there will be problem for generating the output in different languages ..
Experts & Mentors, Please suggest what should I do ??
though, I am going to digg more in that issue to see any solution for this ...
-- Marc Delisle http://infomarc.info
ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
2010/6/22 ADnan hiddenpearls@gmail.com:
On Tue, Jun 22, 2010 at 11:55 PM, Marc Delisle marc@infomarc.info wrote:
ADnan a écrit :
hi,
I am working with XMLWriter Extension for generating XML Documents for SVG,DIA,VISIO formats for generating schema .. but I noticed in XMLWriter .. this extension just provides utf-8 encoding ..
I don't know much about this subject but please explain why generating in utf-8 encoding is a problem.
This issue is making me think that there will be problem for generating the output in different languages ..
Just make sure your data is in UTF-8, eg. use iconv() if the connection is not sending you UTF-8 responses (or, if it is unavailable, warn about it).
On Wed, Jun 23, 2010 at 12:09 AM, Piotr Przybylski piotr.prz@gmail.comwrote:
2010/6/22 ADnan hiddenpearls@gmail.com:
On Tue, Jun 22, 2010 at 11:55 PM, Marc Delisle marc@infomarc.info
wrote:
ADnan a écrit :
hi,
I am working with XMLWriter Extension for generating XML Documents for SVG,DIA,VISIO formats for generating schema .. but I noticed in XMLWriter .. this extension just provides utf-8 encoding ..
I don't know much about this subject but please explain why generating in utf-8 encoding is a problem.
This issue is making me think that there will be problem for generating
the
output in different languages ..
Just make sure your data is in UTF-8, eg. use iconv() if the connection is not sending you UTF-8 responses (or, if it is unavailable, warn about it).
@Piotr I couldn't understand about the iconv() .. It is encoding conversion
utility .. so, If XMLWriter deals data in utf-8 .. It would not be problem ?
things are confusing still :(
--
Piotr Przybylski
ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
2010/6/22 ADnan hiddenpearls@gmail.com:
On Wed, Jun 23, 2010 at 12:09 AM, Piotr Przybylski piotr.prz@gmail.com wrote:
2010/6/22 ADnan hiddenpearls@gmail.com:
On Tue, Jun 22, 2010 at 11:55 PM, Marc Delisle marc@infomarc.info wrote:
ADnan a écrit :
hi,
I am working with XMLWriter Extension for generating XML Documents for SVG,DIA,VISIO formats for generating schema .. but I noticed in XMLWriter .. this extension just provides utf-8 encoding ..
I don't know much about this subject but please explain why generating in utf-8 encoding is a problem.
This issue is making me think that there will be problem for generating the output in different languages ..
Just make sure your data is in UTF-8, eg. use iconv() if the connection is not sending you UTF-8 responses (or, if it is unavailable, warn about it).
@Piotr I couldn't understand about the iconv() .. It is encoding conversion utility .. so, If XMLWriter deals data in utf-8 .. It would not be problem ?
things are confusing still :(
Sorry, I will explain more clearly.
If your database connection uses UTF-8 encoding to return data everything is ok. If you get responses in eg. latin1 encoding, use the iconv extension (iconv() function) to convert encodings, eg.: $latin1_data = 'some string'; $utf8_data = iconv('ISO-8859-1', 'UTF-8', $latin1_data); Then, you feed UTF-8 data to XMLWriter.
It just occured to me that you can ensure that the data you get from MySQL server is always in UTF-8. Instead of converting strings by iconv, just change connection parameters and restore them after you are done with schema export. I believe all MySQL installations should have at least utf8_general_ci and utf8_bin collations available.
On Wed, Jun 23, 2010 at 12:33 AM, Piotr Przybylski piotr.prz@gmail.comwrote:
2010/6/22 ADnan hiddenpearls@gmail.com:
On Wed, Jun 23, 2010 at 12:09 AM, Piotr Przybylski piotr.prz@gmail.com wrote:
2010/6/22 ADnan hiddenpearls@gmail.com:
On Tue, Jun 22, 2010 at 11:55 PM, Marc Delisle marc@infomarc.info wrote:
ADnan a écrit :
hi,
I am working with XMLWriter Extension for generating XML Documents for SVG,DIA,VISIO formats for generating schema .. but I noticed in XMLWriter .. this extension just provides utf-8 encoding ..
I don't know much about this subject but please explain why
generating
in utf-8 encoding is a problem.
This issue is making me think that there will be problem for
generating
the output in different languages ..
Just make sure your data is in UTF-8, eg. use iconv() if the connection is not sending you UTF-8 responses (or, if it is unavailable, warn about it).
@Piotr I couldn't understand about the iconv() .. It is encoding
conversion
utility .. so, If XMLWriter deals data in utf-8 .. It would not be
problem ?
things are confusing still :(
Sorry, I will explain more clearly.
If your database connection uses UTF-8 encoding to return data everything is ok. If you get responses in eg. latin1 encoding, use the iconv extension (iconv() function) to convert encodings, eg.: $latin1_data = 'some string'; $utf8_data = iconv('ISO-8859-1', 'UTF-8', $latin1_data); Then, you feed UTF-8 data to XMLWriter.
It just occured to me that you can ensure that the data you get from MySQL server is always in UTF-8. Instead of converting strings by iconv, just change connection parameters and restore them after you are done with schema export. I believe all MySQL installations should have at least utf8_general_ci and utf8_bin collations available.
How I can change/restore connection parameters ??
-- Piotr Przybylski
ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
2010/6/22 ADnan hiddenpearls@gmail.com:
On Wed, Jun 23, 2010 at 12:33 AM, Piotr Przybylski piotr.prz@gmail.com wrote:
2010/6/22 ADnan hiddenpearls@gmail.com:
On Wed, Jun 23, 2010 at 12:09 AM, Piotr Przybylski piotr.prz@gmail.com wrote:
2010/6/22 ADnan hiddenpearls@gmail.com:
On Tue, Jun 22, 2010 at 11:55 PM, Marc Delisle marc@infomarc.info wrote:
ADnan a écrit : > hi, > > I am working with XMLWriter Extension for generating XML Documents > for > SVG,DIA,VISIO formats for generating schema .. but I noticed in > XMLWriter .. this extension just provides utf-8 encoding ..
I don't know much about this subject but please explain why generating in utf-8 encoding is a problem.
This issue is making me think that there will be problem for generating the output in different languages ..
Just make sure your data is in UTF-8, eg. use iconv() if the connection is not sending you UTF-8 responses (or, if it is unavailable, warn about it).
@Piotr I couldn't understand about the iconv() .. It is encoding conversion utility .. so, If XMLWriter deals data in utf-8 .. It would not be problem ?
things are confusing still :(
Sorry, I will explain more clearly.
If your database connection uses UTF-8 encoding to return data everything is ok. If you get responses in eg. latin1 encoding, use the iconv extension (iconv() function) to convert encodings, eg.: $latin1_data = 'some string'; $utf8_data = iconv('ISO-8859-1', 'UTF-8', $latin1_data); Then, you feed UTF-8 data to XMLWriter.
It just occured to me that you can ensure that the data you get from MySQL server is always in UTF-8. Instead of converting strings by iconv, just change connection parameters and restore them after you are done with schema export. I believe all MySQL installations should have at least utf8_general_ci and utf8_bin collations available.
How I can change/restore connection parameters ??
Ok... sorry for giving you incorrect information. I looked at phpMyAdmin's code and saw how it is handled. As far I I understand code in PMA_DBI_postConnect(), your data is guaranteed to come in UTF-8 encoding. So you don't have to worry about anything, XMLWriter is safe to use.
As for connection parameters, you can look ar MySQL's documentation [1] in your free time, as there is no need to change anything. Sorry for confusing you.
[1] http://dev.mysql.com/doc/refman/5.0/en/charset.html
Hi
Dne Tue, 22 Jun 2010 23:58:18 +0500 ADnan hiddenpearls@gmail.com napsal(a):
On Tue, Jun 22, 2010 at 11:55 PM, Marc Delisle marc@infomarc.info wrote:
ADnan a écrit :
hi,
I am working with XMLWriter Extension for generating XML Documents for SVG,DIA,VISIO formats for generating schema .. but I noticed in XMLWriter .. this extension just provides utf-8 encoding ..
I don't know much about this subject but please explain why generating in utf-8 encoding is a problem.
This issue is making me think that there will be problem for generating the output in different languages ..
All translations in phpMyAdmin are UTF-8 as well as all data you get from MySQL inside phpMyAdmin are in UTF-8, so you really don't have to care about this.
hi,
I am trying to look at the ways that how different export schema's should output the schema. It should be sent the output to Browsers or force downloaded to users ?
*PDF *Schema file should inline or download ? *possiblity:* it can be inline and download but inline is again an issue, we need to clean the headers
*SVG *Schema file should inline or download ? *possiblity:* it can be inline and download but for showing it inline, we need to make frames to output the svg image
*DIA *Schema file should inline or download ? *possiblity:* it can be just download
Regards
On Wed, Jun 23, 2010 at 9:03 PM, Michal Čihař michal@cihar.com wrote:
Hi
Dne Tue, 22 Jun 2010 23:58:18 +0500 ADnan hiddenpearls@gmail.com napsal(a):
On Tue, Jun 22, 2010 at 11:55 PM, Marc Delisle marc@infomarc.info
wrote:
ADnan a écrit :
hi,
I am working with XMLWriter Extension for generating XML Documents
for
SVG,DIA,VISIO formats for generating schema .. but I noticed in XMLWriter .. this extension just provides utf-8 encoding ..
I don't know much about this subject but please explain why generating in utf-8 encoding is a problem.
This issue is making me think that there will be problem for generating
the
output in different languages ..
All translations in phpMyAdmin are UTF-8 as well as all data you get from MySQL inside phpMyAdmin are in UTF-8, so you really don't have to care about this.
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Hi
Dne Sun, 11 Jul 2010 17:51:34 +0500 Adnan hiddenpearls@gmail.com napsal(a):
I am trying to look at the ways that how different export schema's should output the schema. It should be sent the output to Browsers or force downloaded to users ?
*PDF *Schema file should inline or download ? *possiblity:* it can be inline and download but inline is again an issue, we need to clean the headers
I'd prefer download, but I anyway don't use plugins to be able to display PDF inline.
*SVG *Schema file should inline or download ? *possiblity:* it can be inline and download but for showing it inline, we need to make frames to output the svg image
Again, I'd prefer download, mostly because of frames.
*DIA *Schema file should inline or download ? *possiblity:* it can be just download
Definitely download here, AFAIK there is no plugin for browser for this format.
Michal Čihař a écrit :
Hi
Dne Thu, 6 May 2010 16:31:10 +0500 ADnan hiddenpearls@gmail.com napsal(a):
Really ? I am using uptimerobot service who emails me when the server is down. how I can test it ? do u know any other way ?
The server is up, just your content is not there ;-).
Michal, I see the content. Could there be some caching issue on your side.
2010/5/6 Michal Čihař michal@cihar.com:
Hi
Dne Thu, 29 Apr 2010 00:38:15 +0500 ADnan hiddenpearls@gmail.com napsal(a):
First of all, thanks for accepting my proposal. I am very delighted that I got a chance to take part in Great Google Summer of Code Program and phpMyAdmin was my favorite choice. I posted my proposal to my blog. http://www.imblog.info/export-relations-schema-project-google-summer-of-code-2010
Your website seems to be down all the day and returns just "Default Website Page"...
When I visit the blog (by clicking the link you provided here), I get a 404 Page Not Found error.
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
On Thu, May 6, 2010 at 5:31 PM, Dieter Adriaenssens < dieter.adriaenssens@gmail.com> wrote:
2010/5/6 Michal Čihař michal@cihar.com:
Hi
Dne Thu, 29 Apr 2010 00:38:15 +0500 ADnan hiddenpearls@gmail.com napsal(a):
First of all, thanks for accepting my proposal. I am very delighted that
I
got a chance to take part in Great Google Summer of Code Program and phpMyAdmin was my favorite choice. I posted my proposal to my blog. <
http://www.imblog.info/export-relations-schema-project-google-summer-of-code...
Your website seems to be down all the day and returns just "Default Website Page"...
When I visit the blog (by clicking the link you provided here), I get a 404 Page Not Found error.
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Groetjes,
Dieter Adriaenssens
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
I just clicked on link again and it worked . here it is .. http://www.imblog.info/export-relations-schema-project-google-summer-of-code...
ADnan a écrit :
On Thu, May 6, 2010 at 5:31 PM, Dieter Adriaenssens <dieter.adriaenssens@gmail.com mailto:dieter.adriaenssens@gmail.com> wrote:
2010/5/6 Michal Čihař <michal@cihar.com <mailto:michal@cihar.com>>: > Hi > > Dne Thu, 29 Apr 2010 00:38:15 +0500 > ADnan <hiddenpearls@gmail.com <mailto:hiddenpearls@gmail.com>> napsal(a): > >> First of all, thanks for accepting my proposal. I am very delighted that I >> got a chance to take part in Great Google Summer of Code Program and >> phpMyAdmin was my favorite choice. I posted my proposal to my blog. >> <http://www.imblog.info/export-relations-schema-project-google-summer-of-code-2010> > > Your website seems to be down all the day and returns just "Default > Website Page"... When I visit the blog (by clicking the link you provided here), I get a 404 Page Not Found error.I just clicked on link again and it worked . here it is .. http://www.imblog.info/export-relations-schema-project-google-summer-of-code...
It works for me right now, with shift/reload.
-
ADnan -
Adnan
-
Dieter Adriaenssens -
Marc Delisle -
Michal Čihař -
Piotr Przybylski