On 8 Ott, 19:48, JoseAntonio <[EMAIL PROTECTED]> wrote: > Hi, > When I try to insert (or update) data that has foreign characters > (such as 'á') into a table, the data becomes glitched. For instance, > if I try to insert the word 'também' into a table, the table inserts > 'também'. How do I fix that?
I think that 'é' is probably the correct UTF-8 encoding (0xC3A1) for 'á' (U+00E1), when read out as ISO8859-1 instead of UTF-8. Are you sure you're reading the DB data with the correct encoding? Or did you mean that the DB really contains an UTF-8 encoded 'é', that is 0xC383C2A9? --~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
