GeoNames Forum

Hi,

I realize that when a name is converted into ascii name, it is converted in latin1_german2_ci (DIN-2). ie: ü becomes ue, ö becomes ue.

Would not be easier to understand and use latin1_german1_ci (DIN-1) converted characters?

Cheers,

Hi

latin1_german1_ci and latin1_german2_ci are two terms used by mysql for ordering.
For transliteration I think it is common to translate the Umlaute with the additional 'e' character.

Marc

Hi,

I was wondering how ascii conversions are made in the system.. Is there a specific php/sql/? auto conversion function in order to do this?

Regards,

the ascii conversion is a custom made function in java.

Marc

There is a PHP extension for it, it seems to work well:

http://pecl.php.net/package/translit

marc wrote:

the ascii conversion is a custom made function in java.

Marc

Is the source for this function available somewhere?

I am wondering about some German names. For example 'Jülich' is in the dump file as 'Julich'. But it can be found under 'Juelich' via Geonames search (also the URL ends with juelich.html). Why it is not in the dump?

Thank you,
Pavel

Pavel

The search function does a lot of things that are not included in the dump.
Some points are discussed in this thread: http://forum.geonames.org/gforum/posts/list/0/1928.page

Best

Marc