I'm getting characters in my PDF, i've stripped out \r\n \r \n \t, trimmed everything, decoded html entities and stripped tags. Nothing helps. The data is coming from a MySQL database.
Any help would be appreciated.
views:
102answers:
7
A:
Did you try using utf8_decode()? http://php.net/manual/en/function.utf8-decode.php
Itamar Bar-Lev
2010-05-20 07:03:16
Tried it, didn't help
gAMBOOKa
2010-05-20 07:15:33
A:
Try something like this to determine its numeric value and replace it:
$str = 'Hello World';
echo str_replace(chr(ord('')), '[removed]', $str);
Output:
Hello [removed] World
Sarfraz
2010-05-20 07:51:35
A:
Have you tried
$string = "testContainingSpecialCharsäöüöüäüß";
$pdf->Cell(0,0,$string);
What characters should have been displayed instead of those things?
dhh
2010-05-20 07:53:59
A:
FPDF doesn't support unicode characters, so that might be the cause of your problem. There's an extension you could try at http://acko.net/node/56, or alternatively you could switch to another PDF generator library (I recommend TCPDF).
Or you could try using iconv to convert the text from UTF-8 to a supported character set (ie. $str = iconv('UTF-8', 'windows-1252', $str);) if you want to stick with FPDF.
wimvds
2010-05-20 10:37:08
+1
A:
Check string encoding (with mb_detect_encoding) before adding to pdf, is it unicode string? Data in MySQL db can be in unicode but your db connection can use some another encoding.
Zyava
2010-05-20 21:07:14
Interesting. The MySQL db is utf-8. How can I change the encoding of my db connection if that is the case?
gAMBOOKa
2010-05-21 05:55:33
To set connection encoding you should execute next query mysql_query("SET NAMES 'utf8' COLLATE 'utf8_general_ci'") right after mysql_connect. If your db collation isn't utf8_general_ci - set needed collation. If you have access to my.cnf you can add this query to it:init-connect="SET NAMES 'utf8' COLLATE 'utf8_general_ci'". More info there: http://dev.mysql.com/doc/refman/5.5/en/charset-connection.html
Zyava
2010-05-21 18:26:31
A:
Looks like the result of what happens when you copy / paste text from Microsoft word. Does the PDF file contain text from a MS Word document by any chance? That might be your problem. There are some interesting comments for converting and stripping these characters in PHP on the PHP.net website: http://www.php.net/manual/en/function.strtr.php#39383
I am only presuming it is MS Word characters in your PDF file.
Dwayne
2010-05-20 22:49:46
No, it's crawled data from webpages, and the data where the characters show is only filled with tabs and spaces.
gAMBOOKa
2010-05-21 05:53:07