UTF-8 works on Eclipse but fails to work with an exported jar

Question

I am working on a desktop application with `Java` `Swing` and save data on a `MySQL` database in arabic language with using `UTF-8`. When I run the application from `Eclipse` everything work well but when I finish and I export my work to a `runnable jar` using `Eclipse` `export`, nothing related to the database works. - Login doesn't work - When I try to save date to my database in `Arabic` I get `??????` in the database However, as I mentioned earlier, everything work correctly when I run it from `Eclipse`. Can any one help me, I must deliver my work This is a sample of my work: This is how I connect connect my database : ``` static Connection conn = null; static String url = "jdbc:mysql://localhost:3306/"; static String dbName = "gestiondestock"; static String driver = "com.mysql.jdbc.Driver"; static String userName = "root"; static String password = ""; static String unicode= "?useUnicode=yes&characterEncoding=UTF-8"; ``` This is the code for `buttonLogin` `ActionPerformed`: ``` pr…

Accepted Answer

First, you should never convert a String to bytes using an unspecified charset (here you are using the platform default, which could change):

```
passwordlogin.getBytes()
```

Since this is for the bytes you are going to hash, which charset you use doesn't really matter as long as it is consistent. something like `passwordlogin.getBytes("UTF-8")` would seem reasonable.

Also, this is certainly a problematic bit of code:

```
                if(res.next()) {
                    user = new String( res.getBytes(1), "UTF-8");
                    pass =  new String( res.getBytes(2), "UTF-8");
                }
```

it seems to imply that you have a characterset breakdown somewhere.

Lastly, how are you running your jar? Are you specifying a charset on the command line (e.g. `java -Dfile.encoding="UTF-8" ...`).

UTF-8 works on Eclipse but fails to work with an exported jar

Solution

Problem