Hi, I have defined a mysql table with CHARACTER SET 'latin1' COLLATE 'latin1_general_ci' for accept special characters, for instance - Lúcia, Conceição - some time ago I managed to write the column a name of special character but now the name Lúcia is writenn as LÃºcia. The question is, how to define collation to accept special characters?
I have two fields type that send to mysql, jsp input field and jsp textarea field.
If your table is defined to accept and collate on a character set that supports Portuguese, then probably your data is OK, but whatever software you are using to display it hasn't been told to use the same character set (code page).
Being persecuted doesn't in any way prove your righteousness or your beliefs. Many people get persecuted because they are repugnant or annoying. Or just because they can be.
posted 3 weeks ago
I'm using Netbeans to develop and Glassfish as server.