Jump to content
Forgot your email address? ×
  • Create New...
  • 0

[Navicat] Problem with insert query





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?
  • Dislove 1
Link to comment

3 answers to this question

Recommended Posts

  • 0

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • -15% Discount in Metin2 Dev Store (01/10/2021 => 31/12/2021) => Code => 15_PCT_OCT_TO_DEC_2021

  • Read our Rules
  • Activity

    1. 7


    2. 0

      special_item_group and chest apprentice

    3. 2

      Alternative Alternative Zodiac Suit - Ninja M

    4. 0

      character details negative bonus

    5. 0

      Questlib mysql_query function problem

  • Recently Browsing

    • No registered users viewing this page.

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.