-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 rawurlencode was originally intended for URLs, but all it does is encode certian characters- it can be used for anything, and if the percentage of characters is low enough, the returned string is smaller than that which is returned by base64_encode, bin2hex, etc.
That said, it sounds like the problem is not in php itself, but maybe your php_mssql.dll or freetds. Make sure you have the latest version of both. See what versions were working for you- maybe something got broken in a newer release of one of those. On Thursday 27 March 2003 10:45 am, Filip De Graeve wrote: > the problem is, there is already an application running > (written in VB) using that ms sql server ; so i must find a way > to enter the characters in the db in a proper way... > > isn't rawurlencode supposed to be used for urls? > i'm just talking about a plain text string... > > is there anybody else who got any idea ? > thank you for your quick response... > > regards, > > Filip > > "Evan Nemerson" <[EMAIL PROTECTED]> schreef in bericht > news:[EMAIL PROTECTED] > > > -----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----- - -- To achieve adjustment and sanity and the conditions that follow from them, we must study the structural characteristics of this world first and, then only, build languages of similar structure, instead of habitually ascribing to the world the primitive structure of our language. - -Alfred Korzybski -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+g0s0/rncFku1MdIRAqVYAJ9Xxavy/cCPCuvKPNXfURrTv4r7NQCcDwtO VqQFVBtmNtSWenoUTNgUv7U= =Xrm1 -----END PGP SIGNATURE----- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
