[OSM-dev] Osmosis and non-latin characters

[Brett Henderson]

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:           osm at localhost
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 ?