MySQL Forums
Forum List  »  Newbie

Re: Searching database for strings with Swedish characters
Posted by: Paul Johnson
Date: December 13, 2013 11:09PM

Thanks for the instruction on viewing the hex code. That let me diagnose the problem.

The GEDCOM file written by Reunion 10 (the genealogy program on my Mac) is improperly encoding ä as hexadecimal a1cc88. a1 is the hex code for 'a' (in both utf-8 and latin-1) and cc88 is the utf-8 code for the 'combining diaeresis' (i.e. the umlaut). The ä should be encoded as c3a4 instead of a1cc88. This explains why I was unable to successfully search for strings containing ä.

Does anyone know a good way to generate what I consider this bad encoding to the correct one?

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.