Re: [PHP] Re: iconv is messing up a spreadsheet generated by the Spreadsheet Excel Writer

2009-01-16 Thread Ewen Cumming
Good question, according to the author 'There was only a little problem with _calculateSharedStringsSizes() and _storeSharedStringsTable() functions within the Workbook.php. They did not support unicode strings.' Ewen 2009/1/15 Thodoris > > Hi there, I'm not sure if this is the same problem b

Re: [PHP] Re: iconv is messing up a spreadsheet generated by the Spreadsheet Excel Writer

2009-01-15 Thread VamVan
Thanks man that did it :-) . What exactly was the problem you've noticed (I am seeing a diff between the two files bu t I am not sure I fully understand)? -- Thodoris Yes I have previously worked on loads of Greek sites. Some how strange enough I had problems whenever I used UTF-8 to store cont

Re: [PHP] Re: iconv is messing up a spreadsheet generated by the Spreadsheet Excel Writer

2009-01-15 Thread Thodoris
Hi there, I'm not sure if this is the same problem but after I struggled with strange characters in Spreadsheet Excel Writer for some time I wrote an article from my lessons learned: http://research.elabs.govt.nz/generating-excel-spreadsheets-with-maori-macrons-in-php/ It contains some example

Re: [PHP] Re: iconv is messing up a spreadsheet generated by the Spreadsheet Excel Writer

2009-01-15 Thread Thodoris
On Wed, 14 Jan 2009 13:19:31 +0200, Thodoris wrote: Variable_name Value character_set_clientutf8 character_set_connectionutf8 character_set_database latin1 character_set_filesystembinary character_set_results utf8 character_set_serverlatin1 character_set_system

Re: [PHP] Re: iconv is messing up a spreadsheet generated by the Spreadsheet Excel Writer

2009-01-15 Thread Ewen Cumming
Hi there, I'm not sure if this is the same problem but after I struggled with strange characters in Spreadsheet Excel Writer for some time I wrote an article from my lessons learned: http://research.elabs.govt.nz/generating-excel-spreadsheets-with-maori-macrons-in-php/ It contains some example co

Re: [PHP] Re: iconv is messing up a spreadsheet generated by the Spreadsheet Excel Writer

2009-01-14 Thread ceo
> The charset: latin1 and the collation: latin1_swedish_ci. Trivia quiz at a MySQL presentation at my Chicago PHP User Group a few year ago comes in handy! The defaults for MySQL are actually latin1_swedish as that is the native language of the original developer, (?Monty Widenus?) This

Re: [PHP] Re: iconv is messing up a spreadsheet generated by the Spreadsheet Excel Writer

2009-01-14 Thread Nisse Engström
On Wed, 14 Jan 2009 13:19:31 +0200, Thodoris wrote: > Variable_name Value > character_set_client utf8 > character_set_connection utf8 > character_set_databaselatin1 > character_set_filesystem binary > character_set_results utf8 > character_set_server latin1 > ch

Re: [PHP] Re: iconv is messing up a spreadsheet generated by the Spreadsheet Excel Writer

2009-01-14 Thread Thodoris
What's the output of: SHOW VARIABLES LIKE 'character_set%' Variable_name Value character_set_clientutf8 character_set_connectionutf8 character_set_database latin1 character_set_filesystembinary character_set_results utf8 character_set_serverlatin1 charact

Re: [PHP] Re: iconv is messing up a spreadsheet generated by the Spreadsheet Excel Writer

2009-01-14 Thread Nisse Engström
On Wed, 14 Jan 2009 11:33:25 +0200, Thodoris wrote: >> On Tue, 13 Jan 2009 15:51:01 +0200, Thodoris wrote: >> >> >>> Hi gang, >>> I am generating a spreadsheet using the contents of a mysql table. I >>> guess that there is something in the data that causes iconv used in the >>> module's s

Re: [PHP] Re: iconv is messing up a spreadsheet generated by the Spreadsheet Excel Writer

2009-01-14 Thread Thodoris
On Tue, 13 Jan 2009 15:51:01 +0200, Thodoris wrote: Hi gang, I am generating a spreadsheet using the contents of a mysql table. I guess that there is something in the data that causes iconv used in the module's script to generate this error: *Notice*: iconv() [function.iconv ]: De

[PHP] Re: iconv is messing up a spreadsheet generated by the Spreadsheet Excel Writer

2009-01-13 Thread Nisse Engström
On Tue, 13 Jan 2009 15:51:01 +0200, Thodoris wrote: > Hi gang, > I am generating a spreadsheet using the contents of a mysql table. I > guess that there is something in the data that causes iconv used in the > module's script to generate this error: > > *Notice*: iconv() [function.iconv >