Hi,
I found the bug with UTF-8 solution.
Forme use for parameter delimiter a special charakter -> "¶n"
This character (¶ - may be Pilcrow Sign ???
) has not been correctly interpreted in UTF-8 coded database.
Solution: I change this sign to | (Vertical line) in source code.
Files :
- components/com_forme/forme.php
3 times- administrator/components/com_forme/admin.forme.php
2 timesand now my utf8_slovak_ci collated table contain :
| Code: |
firstname=Tóth|
name=Tibor|
firm=Joolma|
...
|
Forme work nice for me with UTF-8 collation.
Next problem with UTF8 is - wrong export data to Excel.
I found nice tutorial here :
http://www.weberdev.com/get_example-3701.html
Based on this tutorial I made changes in administrator/components/com_forme/admin.forme.php file, in function exportdata.
At the end of function I made this chages:
| Code: |
header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header ("Last-Modified: " . gmdate("D,d M YH:i:s") . " GMT");
header ("Cache-Control: no-cache, must-revalidate");
header ("Pragma: no-cache");
//header ("Content-type: application/x-msexcel");
//header ("Content-Disposition: attachment; filename=\"forme.xls\"" );
header ("Content-type: application/csv");
header ("Content-Disposition: attachment; filename=\"forme.csv\"" );
//print $output;
$unicode_str_for_Excel = chr(255).chr(254).mb_convert_encoding( $output, 'UTF-16LE', 'UTF-8');
print $unicode_str_for_Excel;
|
Now, my export working fine to Excel, with correct coded characters.
Hope, help this !
Tibor
Post edited by: thejackal, at: 2007/05/18 03:07
