[Navicat] Problem with insert query

[iwitrag 36]

Hello,

 

I'm trying to import some translated items into my item_proto in Navicat.

There are over 5K queries in that SQL file, but problem is that it get imported wrongly.

 

For example:

 

 

 

get inserted as this

 

 

I have everywhere UTF8 and general_ci collating. Problem is, that metin uses varbinary as container for locale_name and name

 

 

Any ideas?

[iWizz 81]

Change locale_name to varchar and choose latin1.

[martysama0134 6939]

latin1<>utf8 charset conversion fault.

Navicat has this problem if you run queries via F6 console.

[iwitrag 36]

Yeah I see - it fails, well I have changed it to latin2 (czech symbols +ěščřžýá) and changed the SQL file with PS-PAD regullar expressions, so it only updated locale_name (which is what I wanted - just translate).

 

It was hard work, but now it works