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

[Navicat] Problem with insert query


iwitrag

Question

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:

 

 
3pl4.png
 
get inserted as this
 
lr8Yb.png
 
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

Announcements

  • -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

      PHOENIX2 !OLDSCHOOL SERVER, PAYTOWIN REMOVED!

    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.