search

TheTransitClock / transitime

TheTransitClock real-time transit information system
GNU General Public License v3.0
78 stars 30 forks source link

Table structures should be UTF-8 #179

Open BodoMinea opened 4 years ago

BodoMinea commented 4 years ago

During my setup of TheTransitClock, I encountered issues with importing my GTFS archive because of UTF 8 characters in it.

I recreated the table structures with UTF8 columns and tables, and this SQL file for MySQL can be found in my forked repo which I requested to be pulled in PR 177.

Also, I would like to inform you that this didn't completely solve my problem. Even though all database related stuff is now UTF 8 and the import didn't fail anymore, station names in the database contain „?” instead of UTF 8 characters. This is probably a problem with the import mechanism in your source code, which I cannot intervene on with my limited Java knowledge, but I am sure you can fix. Overall functionality of the system is however not affected because it makes heavy use of stop IDs in GTFS, which are limited to ASCII valid chars.

scrudden commented 4 years ago

Hi,

Can you provide a sample file that has this issue?

Thanks, Sean.

BodoMinea commented 4 years ago

stops.txt 1 2 Here you can see the stops.txt file (I can not provide the full feed at this time) and the result in TheTransitClock WebUI. This is after running a GTFS import with the import tool jar on a database created with all UTF8 structures as stated above.

Thanks, Bogdan