Hello,

I want to store a string containing the euro symbol in MySQL via JDBC on Windows 2000.
The euro symbol isn't correctly stored ('?' instead of the symbol).

I'm using :
Windows 2000 (codepage 1252)
MySQL 4.0.12 with charecter-set=latin1
JDBC mysql-connector-java-3.0.8-stable-bin
Java 1.4.2
The euro symbol is passed through a swing gui (AltGr-E on my keybord).

Thanks,
Gauvain

I find a solution outside this forum :
In the JDBC connection URL, add ?useUnicode=true&characterEncoding=windows-1252

Hope this helps,
Gauvain