469,917 Members | 1,489 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,917 developers. It's quick & easy.

PHP and MSSQL character encoding problem.

Hello.
I've a problem (which I believe is a character encoding problem) where I
retrieve data from a MSSQL database and euro and pound sign symbols appear as
? when a do a print_r of the rows immediately after retrieving them from the
database. The data can be seen correctly in the SQL manager program.
I connect to the database using the PEAR DB library.
Has anyone encountered this problem and/or know of a solution.
Thanks,
David.
Jul 14 '08 #1
2 4642

"David Gillen" <be****@RedBrick.DCU.IEwrote in message
news:sl*******************@minerva.redbrick.dcu.ie ...
Hello.
I've a problem (which I believe is a character encoding problem) where I
retrieve data from a MSSQL database and euro and pound sign symbols appear
as
? when a do a print_r of the rows immediately after retrieving them from
the
database. The data can be seen correctly in the SQL manager program.
I connect to the database using the PEAR DB library.
Has anyone encountered this problem and/or know of a solution.
Thanks,
David.
==
yes.. This is one among them..

http://groups.google.co.in/group/com...ef9d056cfe0a96
Jul 14 '08 #2
David Gillen schreef:
Hello.
I've a problem (which I believe is a character encoding problem) where I
retrieve data from a MSSQL database and euro and pound sign symbols appear as
? when a do a print_r of the rows immediately after retrieving them from the
database. The data can be seen correctly in the SQL manager program.
I connect to the database using the PEAR DB library.
Has anyone encountered this problem and/or know of a solution.
Thanks,
David.
lemme guess. db = utf-8, http-equiv Content-Type is utf-8 but apache is
not.

Add this to your .htaccess
AddDefaultCharset UTF-8

Floortje
Jul 14 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Safalra | last post: by
4 posts views Thread by HeroOfSpielburg | last post: by
8 posts views Thread by Agnes | last post: by
18 posts views Thread by james | last post: by
11 posts views Thread by ralphie | last post: by
17 posts views Thread by =?Utf-8?B?R2Vvcmdl?= | last post: by
5 posts views Thread by eisenstein | last post: by
10 posts views Thread by Paul W | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.