"?" instead of euro symbol

[apffal]

I get "?" instead of Euro symbol, as a result, in a JDBC text field.
Is it possible to solve this ?
Thanks.

 

[stefanwagner]

what's a jdbc text field?

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung

 

[apffal]

I mean : a text field for getting results with JDBC

 

[stefanwagner]

well - moving real slow:
I dont know a text field.

Might you mean an TextField or JTextField? (awt, swing)?

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung

 

[apffal]

Yes, I get results in a TextField from a mysql database

 

[stefanwagner]

Symbol-problems may have different source and solutions:
The database handles encodings.
The OS handles encodings.
Your java-program handles encodings.

Can you enter your symbol manually/ programmatically?
Did you write the symbol to console and to a file?
Can you write the result from the database to console and to a file?

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung

 

[apffal]

I enter all my data in Mysql - and euro symbols display correctly if I make a search, for instance in phpMysqlAdmin.
They change to "?" only if I search with a Java program via JDBC.
And I cannot fix that - if I edit the TextField, save the change and restart the application, I get "?" instead of "€" again !

 

[stefanwagner]

Can you verify your result from the database by analyzing the result on byte-level?

Beside different ideas about encoding, there might also be a problem by the fonts used.

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung

 

[apffal]

Problem with fonts ?
In java program, I'm using "Helvetica", Font.PLAIN, 12.
What should I use ?

 

[stefanwagner]

When I understood your previous posting correctly, you may insert the Euro-Symbol with your keyboard, so the font doesn't make trouble in this case.

Your general database-settings work too, because you tested with php-mySqlAdmin.

What is the byte-value you get via jdbc?
Did you write it to a file?
To console (System.out.println (buggy)?

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung

 

[apffal]

Excuse me for delay !
I found this is a encoding problem, since my database uses ISO-8859-1, which has no euro symbol support, and ISO-8859-15 has it.
So, I've changed
String url= "jdbc:mysql://127.0.0.1/test";
to
String url= "jdbc:mysql://127.0.0.1/test?useUnicode=true&characterEncoding=ISO-8859_15";
And now I get a NullPointerException
What's wrong ?

 

[stefanwagner]

Who is throwing the NPE?
The jdbc-driver?

sorry - I'm not an mySql-guy.


seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung

 

[apffal]

I receive the NPE in terminal window (either in windows or linux), when I execute java program and try get results from database

 

[Diancecht]

Any stacktrace?

Maybe you need to configure something at database manager

Cheers,

Dian

 

[apffal]

As I said, in Mysql, euro symbols display correctly if I make a search, for instance with phpMysqlAdmin.
They change to "?" only if I search with a Java program via JDBC.
So, it's a Java encoding problem.
Something wrong with my String ?url= "jdbc:mysql://127.0.0.1/test?useUnicode=true&characterEncoding=ISO-8859_15"

 

[stefanwagner]

I receive the NPE in terminal window (either in windows or linux), when I execute java program and try get results from database

<very friendly>
Do you get a stacktrace or only a single errormessage?
</very friendly>

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung

 

[jur1]

I solved the problem, changing utf-8 database collation to default - now, I get euro symbol via JDBC
Thanks, anyway !

 

[Diancecht]

What is "utf-8 database collation"?

Cheers,

Dian

 

[jur1]

Myslq table utf-8 collation

 

[Diancecht]

Ahhhh, that makes thing a lot clearer...

I guess that is a database configuration parameter that has nothing to do with Java.

Cheers,

Dian