Latest posts for the topic "Ascii Name Conversion"

Ascii Name Conversion

travelusta — GMT

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,

Re:Ascii Name Conversion

marc — GMT

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

Re:Ascii Name Conversion

ererciyes — GMT

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,

Re:Ascii Name Conversion

marc — GMT

the ascii conversion is a custom made function in java. Marc

Re:Ascii Name Conversion

SEO — GMT

There is a PHP extension for it, it seems to work well: http://pecl.php.net/package/translit

Re:Ascii Name Conversion

pavel.horal — GMT

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

Re:Ascii Name Conversion

marc — GMT

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