I tried it ; it doesn't work. é ë è results into Ú Þ Ù standard, & using htmlentities é ë è results into é è ë using htmlspecialchars é ë è results into %E9%20%E8%20%EB using rawlurlencode
The charset ISO-8859-1 (western europe) is supported in my apache, php, and on the global win 2K system. (it's native!) Any other clues ? Cheers! "Evan Nemerson" <[EMAIL PROTECTED]> schreef in bericht news:[EMAIL PROTECTED] > -----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