Problem in MySql with special characters.

[Cezar Apulchro]

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.
Thanks.

[Tim Moores]

now the name Lúcia is writenn as Lúcia

Where is it written like that? Keep in mind that many text consoles can not handle non-ASCII characters.

[Tim Holloway]

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).

[Cezar Apulchro]

I'm using Netbeans to develop and Glassfish as server.

[Tim Moores]

Tim Moores wrote:Where is it written like that?

[Cezar Apulchro]

Is written in my mysql table and in my jsp table when I load to table.

[Stephan van Hulst]

Before you output the value to JSP, print the byte sequence to your output window like this:

System.out.println(Arrays.toString(name.getBytes(Charset.forName("UTF-16BE"))));

Share the byte sequence with us.

If the sequence correctly encodes "Lúcia", the problem is that your web page doesn't interpret the string correctly. Otherwise, you stored the wrong value in the database.

[Cezar Apulchro]

Hi, this is a java class that I took on the web to see the generated content but is not showing any. Where am I going wrong?

package com.itcsystems.itc_systems_web_mv00;

import java.io.UnsupportedEncodingException;
import java.nio.charset.Charset;
import static java.time.chrono.ThaiBuddhistEra.BE;
import java.util.Arrays;

/**
 *
 * @author Cezar Apulchro
 */
public class TstNome
{
    public static void main(String[] args)
    {
        String nome = "Lúcia";
        System.out.println("Nome: " + nome);
        
        byte[] bArray1 = nome.getBytes();
        
        byte[] bArray2 = nome.getBytes(Charset.forName("UTF-16"));
        
        byte[] bArray3 = null;
        
        try
        {
            bArray3 = nome.getBytes("UTF-16BE");
        }catch(UnsupportedEncodingException useex)
        {
            useex.printStackTrace();
        }
        System.out.println("Default charset of platform : \n"
                + Arrays.toString(bArray1));
        
        System.out.println("\nStatic method of charset : \n"
                + Arrays.toString(bArray2));
        System.out.println("\nPassed UTF-16BE charset name : \n"
                + Arrays.toString(bArray3));
    }
}

[Cezar Apulchro]

I solved the problem of accentuation for portuguese, in my input fields the special characters like ç, ^, ´, are being shown as they should, but in my jsp table are not working.
I used the command:

request.setCharacterEncoding("UTF-8");

As I said input fields and table mysql are ok.
Thanks.

[Stephan van Hulst]

Good job solving it, have a cow!

[Cezar Apulchro]

How to close this contact?

Problem is solved.

Thanks.

[Tim Holloway]

It's been marked solved. Nothing more to do.