character set problem
| From: | Filip De Graeve | Date: | Thu, 27 Mar 2003 17:46:09 +0000 |
| Subject: | character set problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-141268@lists.php.net to get a copy of this message | ||
Hello,
Using PHP 4.3.1 on a Windows 2k/Apache,
i am trying to insert some text like "Test é à ë" into a
MS SQL database.
The result I get using the query analyzer :
Test Ú Þ Ù
is not the same as you can see for yourself.
However; ms sql supports those characters when
i insert them directly into the query analyzer.
My locales support those characters (.be locals),
and i configured the php.ini to support the iso-8859-1 charset
(and use the mssql dll extension).
What's also weird, is that the function htmlspecialchars has
no effect on the result, whilst htmlentities does have one; but then the
textfield looks like " Test é è ë "
which wasn't exactly the point.
I used an older version of php once;
( i believe it was 4.1.1 or something) and there wasn't any bug
regarding charsets etc (on a ms sql database).
Can anybody give me any clue where to look
or what to do?
thank you,
regards
Filip
filip@curious.be