[Geoserver-users] Mysql datastore charset error

I'm using geoserver 1.5.4

I have utf-8 encoded tables in mysql database as a feature source.They
contains some Chinese characters. However, the result of WMS has charset
error which the Chinese char displayed as "???".

I don't know how to handle this problem. It seems that the same thing
with PostgreSQL is all right. I have checked the configuration and even
the code , nothing found.

Could help me?

ËïÄþ ha scritto:

I'm using geoserver 1.5.4

I have utf-8 encoded tables in mysql database as a feature source.They
contains some Chinese characters. However, the result of WMS has charset
error which the Chinese char displayed as "???".

I don't know how to handle this problem. It seems that the same thing
with PostgreSQL is all right. I have checked the configuration and even
the code , nothing found.

Could help me?

The MySql datastore is not actively mantained at the moment, we
don't have any developer really familiar with MySql either.
Yet, I don't think we're doing anything special in PostGis to make it
properly use the UTF-8 charset. Do you know if any special setting is
needed in the MySql JDBC driver or jdbc url connection to make it work
with UTF-8 chars?

Cheers
Andrea

Can you verify that the data shows up correctly when you query it from
the command line? I ran into this problem a while ago as well when
trying to load data with extended latin characters into a mysql
database. I agree with andrea... the datastore does not do anything
special that i know of to support extended charsets.

Andrea Aime wrote:

ËïÄþ ha scritto:

I'm using geoserver 1.5.4

I have utf-8 encoded tables in mysql database as a feature source.They
contains some Chinese characters. However, the result of WMS has charset
error which the Chinese char displayed as "???".

I don't know how to handle this problem. It seems that the same thing
with PostgreSQL is all right. I have checked the configuration and even
the code , nothing found.

Could help me?

The MySql datastore is not actively mantained at the moment, we
don't have any developer really familiar with MySql either.
Yet, I don't think we're doing anything special in PostGis to make it
properly use the UTF-8 charset. Do you know if any special setting is
needed in the MySql JDBC driver or jdbc url connection to make it work
with UTF-8 chars?

Cheers
Andrea

!DSPAM:4007,47907a1a272655409313003!

------------------------------------------------------------------------

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

!DSPAM:4007,47907a1a272655409313003!

------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4007,47907a1a272655409313003!

--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org