Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Address encoding problem in 3.0 #1298

Closed
tananaev opened this issue Jul 10, 2015 · 8 comments
Closed

Address encoding problem in 3.0 #1298

tananaev opened this issue Jul 10, 2015 · 8 comments

Comments

@tananaev
Copy link
Member

Examples:

nominatim/reverse.php?format=json&lat=-20.2453300&lon=-70.0942000&zoom=18&addressdetails=1
nominatim/reverse.php?format=json&lat=49.607605&lon=8.517553&zoom=18&addressdetails=1
@MRokas
Copy link
Contributor

MRokas commented Aug 19, 2015

It happens with all 3 reverse lookups. They return everything correct, so I would guess error is in the code (would help, but I don't trust my java knowledge, which is barely above 0)

@tananaev
Copy link
Member Author

I guess the problem is when the data is written into the database. What database are you using?

@MRokas
Copy link
Contributor

MRokas commented Aug 21, 2015

Tried default and MySQL. Utf8_general_ci on MySQL

@tananaev
Copy link
Member Author

Make sure you have following parameters in your database.url parameter:

useUnicode=yes
characterEncoding=UTF-8

@MRokas
Copy link
Contributor

MRokas commented Aug 24, 2015

I've both of them, and even tried refreshing page.
Not really sure what the issue could be :/

@tananaev
Copy link
Member Author

Is the encoding incorrect in the web interface or in the database as well?

@MRokas
Copy link
Contributor

MRokas commented Aug 24, 2015

Both of them.

@tananaev
Copy link
Member Author

Try to use utf8mb4 encoding in MySQL instead of simply utf8.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants