Can you please show the output of the status command? Check the four characterset fields at the bottom. All should be set to utf8. Any non-utf8 values might cause the problem. Osmosis should just work if the database is configured correctly.
mysql> status -------------- mysql Ver 14.12 Distrib 5.0.45, for Win32 (ia32) Connection id: 4 Current database: Current user: [EMAIL PROTECTED] SSL: Not in use Using delimiter: ; Server version: 5.0.45-community-nt MySQL Community Edition (GPL) Protocol version: 10 Connection: localhost via TCP/IP Server characterset: utf8 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8 TCP port: 3306 Uptime: 3 min 10 sec Threads: 1 Questions: 8 Slow queries: 0 Opens: 12 Flush tables: 1 Open tabl es: 6 Queries per second avg: 0.042 Pol Robeys wrote: > Hi, > > I'm tyring to import an .osm (Bulgaria) file with non-latin > characters into a MySQL database. > I set the character encoding for the database to utf-8. > When I look in the input file, I can see the non-latin characters. > However, after the input, the database contains question marks for > non-latin characters. > Is there something additional I should do ? _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
