iwitrag 36 Posted November 16, 2014 Share Posted November 16, 2014 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? 1 Link to comment Share on other sites More sharing options...
Solution iWizz 82 Posted November 16, 2014 Solution Share Posted November 16, 2014 Change locale_name to varchar and choose latin1. 1 Link to comment Share on other sites More sharing options...
Honorable Member martysama0134 7204 Posted November 16, 2014 Honorable Member Share Posted November 16, 2014 latin1<>utf8 charset conversion fault. Navicat has this problem if you run queries via F6 console. 1 Check out my GitHub Link to comment Share on other sites More sharing options...
iwitrag 36 Posted November 16, 2014 Author Share Posted November 16, 2014 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now