MYSQL / Encoding

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

MYSQL / Encoding

François-Xavier PRUNAYRE
Hello list,

I'm looking into GeoNetwork DB connection ... I've trouble with special
characters (éàèç....) when using Mysql DB ... Any advice about the encoding
to use when creating DB ?

Thanks for your help.

François-Xavier Prunayre
International Office for Water
Web IOW : www.oieau.org

 


--
Ce message a ete verifie par MailScanner pour des virus ou des polluriels et rien de suspect n'a ete trouve.

Les donnees et renseignements contenus dans ce message sont personnels, confidentiels et prives. Toute publication, utilisation ou diffusion, meme partielle, doit etre autorisee.

Any data and information contained in this electronic mail is personal, confidential and secret. Any total or partial publication, use or distribution must be authorized.



Reply | Threaded
Open this post in threaded view
|

RE: MYSQL / Encoding

François-Xavier PRUNAYRE
Thanks a lot. Works fine also with connector 3-0-9 and mysql 5.
Francois
 

-----Message d'origine-----
De : Stefano Giaccio [mailto:[hidden email]]
Envoyé : mardi 15 mars 2005 05:10
À : François Prunayre
Objet : Re: [GeoNetwork-users] MYSQL / Encoding

Hello François,

I'm using MySQL 4.0 with the mysql-connector-java-2.0.14-bin.jar jdbc
connector.

It correctly deals with special characters using the following connection
string:

jdbc:mysql://127.0.0.1/<database_name>?autoReconnect=true&useUnicode=true&ch
aracterEncoding=utf-8&mysqlEncoding=utf8

Please note that you'll have to substitute & with &amp; in config.xml

Bye
Stefano



On Monday, March 14, 2005, at 01:42PM, François Prunayre
<[hidden email]> wrote:

>Hello list,
>
>I'm looking into GeoNetwork DB connection ... I've trouble with special
>characters (éàèç....) when using Mysql DB ... Any advice about the
>encoding to use when creating DB ?
>
>Thanks for your help.
>
>François-Xavier Prunayre
>International Office for Water
>Web IOW : www.oieau.org
>
>
>
>
>--
>Ce message a ete verifie par MailScanner pour des virus ou des polluriels
et rien de suspect n'a ete trouve.
>
>Les donnees et renseignements contenus dans ce message sont personnels,
confidentiels et prives. Toute publication, utilisation ou diffusion, meme
partielle, doit etre autorisee.
>
>Any data and information contained in this electronic mail is personal,
confidential and secret. Any total or partial publication, use or
distribution must be authorized.

>
>
>
>-------------------------------------------------------
>SF email is sponsored by - The IT Product Guide Read honest & candid
>reviews on hundreds of IT Products from real users.
>Discover which products truly live up to the hype. Start reading now.
><a href="http://ads.osdn.com/?ad_ide95&alloc_id396&op=click">http://ads.osdn.com/?ad_ide95&alloc_id396&op=click
>_______________________________________________
>GeoNetwork-users mailing list
>[hidden email]
>https://lists.sourceforge.net/lists/listinfo/geonetwork-users
>GeoNetwork OpenSource is maintained at
>http://sourceforge.net/projects/geonetwork
>
>

--
Ce message a ete verifie par MailScanner pour des virus ou des polluriels et
rien de suspect n'a ete trouve.

Les donnees et renseignements contenus dans ce message sont personnels,
confidentiels et prives. Toute publication, utilisation ou diffusion, meme
partielle, doit etre autorisee.

Any data and information contained in this electronic mail is personal,
confidential and secret. Any total or partial publication, use or
distribution must be authorized.


--
Ce message a ete verifie par MailScanner pour des virus ou des polluriels et rien de suspect n'a ete trouve.

Les donnees et renseignements contenus dans ce message sont personnels, confidentiels et prives. Toute publication, utilisation ou diffusion, meme partielle, doit etre autorisee.

Any data and information contained in this electronic mail is personal, confidential and secret. Any total or partial publication, use or distribution must be authorized.