Re: character set problem

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" <evan@coeus-group.com> schreef in bericht news:200303271035.49720.evan@coeus-group.com... > -----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 &eacute; &egrave; &euml; " > > 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 > > - -- > 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----- >