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 ??
--
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



--
Muhammad Adnan
Twitter: @hiddenpearls
I blog too do u know ? http:// www.imblog.info
Failure takes you higher than success ..!