Jump to content

Charset in db

Avisek
 Share

Recommended Posts

Avisek Community Regular

Avisek 8

Posted
Posted (edited)

Hello,
I have made quest, that inputs values into database "report".

I input those characters:
input.png

And in db saves:
output.png

I have set charsets (db in fields and options), also in charset of server.
options.png

fields.png

charset.png

 

I really dont know, where is problem..

Could you help me, please? :/

 

Edited by Metin2 Dev
Core X - External 2 Internal
Link to comment
Share on other sites
  • Replies 5
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

DarkAng3l
DarkAng3l

A ty si snad myslíš, že to je nemožné ? Já ho osobně předělal celý do UTF-8 a pokud ti mohu doporučit, tak se o to ani nepokoušej, protože skončíš hned na začátku. To, že máš tabulku v UTF-8 je

DarkAng3l Contributor

DarkAng3l 25

Posted
Posted (edited)
2 hours ago, SemperFi said:

Ty vole pozor, tady máme borce, co přepsal celý server do UTF-8.
OMEGALUL

A ty si snad myslíš, že to je nemožné ? Já ho osobně předělal celý do UTF-8 a pokud ti mohu doporučit, tak se o to ani nepokoušej, protože skončíš hned na začátku.

17 hours ago, Avisek said:

Hello,
I have made quest, that inputs values into database "report".

I input those characters:
input.png

And in db saves:
output.png

I have set charsets (db in fields and options), also in charset of server.
options.png

fields.png

charset.png

 

I really dont know, where is problem..

Could you help me, please? :/

 

To, že máš tabulku v UTF-8 ještě neznamená, že ukládaná data jsou v tomto kódování. Jak již píše T4Ump - server je napsán v kódování latin, což znamená (CP1250, CP1252, CP1256 atp). Dokud nepřepíšeš připojení k databázi, že má používat UTF-8, tak to v Navicatu uvidíš jako rozsypanej čaj.
 

Poradil bych ti, aby sis napsal kus kódu, abys to viděl správně, ale to je asi zbytečné v tomto případě.

Edited by Metin2 Dev
Core X - External 2 Internal
  • Love 1
Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share
Go to topic listing

Announcements



  • Similar Content

  • Activity

    1. 11

      Enable Scaling for Buttons

      asdasdasdasd
      mozgur in Programming & Scripts
    2. 11

      Multi Language System

      char.cpp in void CHARACTER::ChatPacket this: #ifdef ENABLE_MULTILANGUAGE std::string sTranslateText; if (type != CHAT_TYPE_COMMAND) { if (GetLang() > MAX_LANGUAGES) sTranslateText = LC_TEXT(DEFAULT_LANGUAGE, format); else sTranslateText = LC_TEXT(GetLang(), format); } #endif and this a little under: #ifdef ENABLE_MULTILANGUAGE int len = vsnprintf(chatbuf, sizeof(chatbuf), format, args); if (type != CHAT_TYPE_COMMAND) len = vsnprintf(chatbuf, sizeof(chatbuf), sTranslateText.c_str(), args); #else Is just not needed at all and makes this problem. Every shout, party, info etc chat would go to LC_TEXT what adds a "@0949" to the message if translation not found in in locale.cpp's locale_find (it's hidden but you can see in /n for example or if you write messages to console) and that "@0949" makes accents bad plus you get a syserr each time somebody shout or party or guild chat etc. So you can delete this 2 ifdef if you already set every LC_TEXT(DEFAULT_LANGUAGE / LC_TEXT(TRANSLATE_LANGUAGE and I'm sure you did because LC_TEXT's new first attribute is mandatory so if you didn't then you couldn't compile the game. So that's why I said this is just not needed at all and can be removed. (Sorry for bumping old topic but I wanted to share the fix)
      TMP4 in Features & Metin2 Systems
    3. 0

      [FREE DESIGN] Interface + Logo + Discord Banner and Avatar

      Download Alternative download links → GG Drive Hello all, I decided to offer this package for free to someone who really needs it. The archive contains everything you need to modify this template Careful! The interface is PSD only You can contact me anytime if you want to edit something Have fun!
      • 1
      • Love
      unqdesign in 2D Graphics
    4. 4

      Feeding game source to LLM

      You don't need to train it on your source code. You just need to take a good model and give it more context. For example I use Github Copilot to help me with some trivial task while coding. If I need info about the whole source I just use @workspace in the chat when I ask it a question and then he has more context about the source.
      Abel(Tiger) in Metin2
    5. 0

      Quest 6/7 Problem

      Hi, sorry for my terrible English. I have a problem with system 6/7 of these server files. [Hidden Content] They do not bring the system quest. I don't know much about programming quests, I tried to adapt a quest from other server files, but I only managed to get it to open the bonus window. Does anyone have the quest or can do it? I would greatly appreciate the help I use '--' just for identify the quest_function I had and the quest I try to adapt [Hidden Content]
      Rags in Community Support - Questions & Answers
    6. 5

      Effect weapons

      I have the .mde and the .mse next to each other however this does not really work.. I have the correct EFFECT_REFINED + (the number of the enum value) in the playersettingmodule.py I applied the effect on InstanceBase.cpp (considering the item's vnum) with no luck.. Do I miss something? Does those files have a prefix path or something? Like if I put them on the wrong path (think about the granny texture) will not find them at all?
      white in Community Support - Questions & Answers
    7. 0

      [C++] Fix Core Downer Using Negative Number in GM Codes

      INTRODUCTION & PROBLEM Hello, today we will fix a few errors, especially the error that caused the core down by giving an unexpected negative (-) arg (number) in the commands (Example; /mob 101 -1), and we will also regulate the use of "ChatPacket" in this functions. WHY ? GMs are already part of the team, you may ask why we need this, you are right, but do not forget that a GM who does not have coding knowledge may accidentally trigger this, let's not leave it to chance. SOLUTION The process we will do is simple, it will be enough to make sure that the given arg value is within the range we want, let's get started. [Hidden Content]
      • 11
      • Good
      • Metin2 Dev
      • muscle
      • Love
      MT2Dev in Bug Fixes
    8. 3

      Crystal Metinstone

      Awesome!! Can u make it with other colors too? Like ice fire forest lightning ?
      asdasd1234 in Metinstones
    9. 4

      Feeding game source to LLM

      ChatGPT is obsolete today honestly. I use claude-3-opus LLM daily for commercial programming and it exceeds chatgpt by a mile. When it comes to token size it's like you said, not possible straight away with chatgpt. There's however a way to go around this with some additional layers of complexity like Cursor Editor although be warned its closed source. It's basically a fork of vscode that let's you ask LLMs about your code. Also you can ask it to write anything and it has the context of your entire codebase. I tested it a few months back and it wasn't bad honestly. I told it to explain some shit-code written by ymir that I didn't understand and it did quite well.
      b6d4a82c15 in Metin2

  • Recently Browsing

    • No registered users viewing this page.
×
×
  • Create New...

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.