Character set problem

[timcclayton]

Hello all.

I have a virtual airline with a handful of pilots at the moment. One of the pilots is from the Faroe Islands and when he signed up with the airline
using our PHP and MySQL settings the ú character in his name appeared perfectly in MySQL.

However, having now added an FsPassengers export page to the site, whenever he exports his flights, the ú character mysteriously changes to a % symbol
instead!

I have done some investigation of encoding and character sets, but it would seem (although I can't be sure) that either the FsPassengers export engine
or the PHP files associated with the export process that I downloaded are causing the problem.

Is this the case and, if so, is there a way to add an encoding entry to one of the PHP files to solve this problem. I can see that over time, more
pilots will be joining with accented characters in their names, and it is no fun manually editing each entry every time.

Thanks in advance for any pointers.
Tim.

[runibl]

That would be me he's talking about.
Just to add that this is also an issue on FsPassengers own Virtual Airline Demo section. I have seen quite a few there, that have the same "%" sign in
their name.

[Drew]

I was going to post Runi had this same problem on fspworldtour, but that wouldnt help fix you problem, so i didnt bother

[runibl]

Drew wrote:
I was going to post Runi had this same problem on fspworldtour, but that wouldnt help fix you problem, so i didnt bother

That's right i forgot to mention that one as well.

[timcclayton]

I should have mentioned his name, being so well known on these forums! I am wondering whether there is anything I can change in the default "VA export PHP" files to solve this problem, or whether it is a "built-in" issue.



Post Edited ( 08-28-06 23:51 )

[Drew]

I would assume you can fix it by doing something in the php coding.

Didnt Mark (dbe) fix it in the end? or did you (Runi) use a different pilot?

I also know i was using a pilot called 'Drew Williams' but on the flight log page he made it so it only displayed 'Drew', so maybe he can
help you.

[runibl]

I just checked his site. If you open one of my flight reports, then you will still see R%ni.

[timcclayton]

I think in that case, Dan might be best placed to let us know. I know he's busy - is it fair to PM/e-mail him or is it best to wait for him to scour
the forums for this post?

[runibl]

I think it should be alright to PM or Email him.

[timcclayton]

OK I have PM'd, so we'll wait and see (fingers crossed!)

[DanSteph]

Well only some test can solve this, can you grant me the access ? either by mail or in Pm ?

best

Dan

[timcclayton]

PM sent Dan

[DBE]

Drew wrote:
I would assume you can fix it by doing something in the php coding.

Didnt Mark (dbe) fix it in the end? or did you (Runi) use a different pilot?

I also know i was using a pilot called 'Drew Williams' but on the flight log page he made it so it only displayed 'Drew', so maybe he can
help you.

All I did was parse the pilot's name upon listing the flights and replaced the names accordingly. Nothing fancy indeed..

[timcclayton]

Just to update everyone - I have PM'd Dan again about this but have heard nothing back. If anyone reading this can get hold of Dan to find out its
status I would be grateful.

[Ceemosp]

I've got an easy solution Runi.....just change your name

Greetz Carsten