-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 can you do a rawurlencode() on the data before you put it in the DB, and a rawurldecode when you suck it out? It's a hack, but it would prolly work fine.
On Thursday 27 March 2003 09:46 am, Filip De Graeve wrote: > 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 > [EMAIL PROTECTED] - -- Prisons are built with stones of Law, Brothels with bricks of Religion. - -William Blake -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+g0SB/rncFku1MdIRAofUAJ0TbYKVYZ+tPski2l8QNT6dkDkh8wCdEjux 8jW37HvPuBZg5aZbZywOF+0= =qVVT -----END PGP SIGNATURE----- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
