PHP+Apache+MsSQL+national chars=#¤%#

Anon

In 2001 there was an topic from Joakim:

"If i have swedish chars in my PHP code (as Headings or plain text) it works great, but when i try to send swedish chars to or from MsSQL it completely screws it up. The MsSQL is running with Swedish/Finnish charset.

PHP won't accept swedish chars at all.
If I send an "åäö" as a login it fails to find the desired user. If i get a simple "Select * from ..." and some of the fields contain swedish chars it shows me the wrong ones. "

I have the same problem - the only difference is using Czech characters in the database. PHP output itself is OK but data readed from database are incorrect - on the same page. Characters sended to the database are incorrectly interpreted too.

Can anyone help to solve the problem?

gljaber

I've had the same problem with the Welsh langauge, which includes vowels with the little hat on them!

It's a problem with the page encoding, ISO standard is fine with some of the literal characters, but it did not contain the w we wanted. UTF-8 does support every character we need, and from the looks of it what you need, but I've had to parse every output from our database, and replace the offending characters with the correct UTF code:

e.g. typing &#373 would render as a w^

To avoid the parse you could store the character in the "&#XXX" in the database itself, but this would create problems with searching. I've also included a header in all the pages to ensure the encoding is set to be UTF-8.
I'm sure you could google for the UTF character codes for international characters.

HTH

glj

gljaber

Sorry, it rendered the character, the code for w^ is ampersand-hash-373 without the spaces in them. Look at the page source to actually see it!

Sorry 😉

glj

Anon

All the data in database are stored with Windows-1250 codepage, PHP pages has the same codepage. This codepage fully cover all character needs of our language (Czech).

Problem is in the retrieving and sending data from/to database. The transfer mechanism is broken!

gljaber

So the data looks fine in the database, but not in the browser???
If so, can you look at the source of a page where the characters are showing incorrectly, and see if the characters are correct in the source. If they are, then the transfer is fine, but the browsers rendering of them is not (see my first post). Otherwise, I have no idea 🙂

Have a nice weekend!

glj