[Solved]Export to VA SQL problem

[WEA-CAS]

Heii
I had the same problem.. but we have fix that problem.

flight wea036 LEMD-->UKFF flight time 4H 1727nm
UKKF hedder Simferopol...i ukraine. (Simferopol' )

( ' ) That was the problem.


Well i have done some more research on this... and i think the problem is the SQL Database.
The problem is that i can't change the MySQL charset and MySQL connection collation on weaf.eu SQL.
The problem is that the weaf.eu server are running a old SQL version for some reason don't allow the use of ' this charset
weaf.eu SQL server is version 4.0.21 and todays new version is around v.5.0.XX.
We still have some flights that has been uploaded in year 2006 that has the ' charset. And we have problem to view them now

The name was: KORD - Chicago O'Hare Internatio - Usa Chicago O'Hare Internatio Usa

As you may notice, we got a SQL error.

To make SQL servers to allow this type of ' charset we need to change the MySQL charset and MySQL connection collation to use:

MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: utf8_unicode_ci

I have been searching at FsPassengers forum for same problem, nobody else has this charset problem with this ( ' ).
We have two opinion:
1. Ask the web hotel to upgrade the SQL to the newest version.
2. One of us have to take the hard way and change both files IcaoDbFspX.cfg and Icao_db.cfg. And remove all ( ' ) from the list.

We think we found the problem about WEA-CAS exporting problem. Som airports has this sign ( ' ) in its name. What we did was:
Opened his IcaoDbFspX.cfg in a texteditor(Notepad) (path=X:\Programfiler\Microsoft Games\Flight Simulator X\Fspassenger\Config).
Searched for dest/arr airport we thought was the problem. Then we removed the sign ( ' ) from the airport and saved the file. The he
launche FSX and tried to export the flight again and VOILA.......it worked like a charm. So for those who might get this problem can either
ask for help ot just do as we did

P.S. Do a BACKUP of your database folder...just incase

Hope that can help you..