Cyrillic support

  • Resolved apopovski

    (@apopovski)


    11 months, 2 weeks ago

    Hello,

    I just bought the plugin and playing with to learn around its concept. One thing that came up from start is entering cyrillic text in a text field. Its not accepted to be written in the table and when the same text entered in latin is accepted. Database used is the native from wordpress site. I assume its an issue with the slug in wordpress but since its database related I was wondering how to resolve it. Any help is appreciated.

    Thanks
    Alex

Viewing 9 replies - 1 through 9 (of 9 total)
  • Leeberty

    (@aaronvincentlee)

    11 months, 2 weeks ago

    Hi Alex,

    I understand that you’re experiencing an issue about entering cyrillic text. Let me help you with this.

    But first, can you please clarify where the table came from? Was it handled remotely, or, have you created the table in Table Designer?

    We’ll wait for your reply.

    Thread Starter apopovski

    (@apopovski)

    11 months, 2 weeks ago

    Hello,

    Thank you Leeberty for the help. Its just a test table created via table designer in the wordpress database.

    Thanks

    Alex

    Leeberty

    (@aaronvincentlee)

    11 months, 2 weeks ago

    Hi @apopovski ,

    Thanks for getting back!

    When you declare a string variable, it is treated as varchar by default.

    What’s best is to change the datatype to Nvarchar. Nvarchar stores UNICODE data. If you have requirements to store UNICODE or multilingual data, nvarchar is the choice.

    Also, please see: https://stackoverflow.com/questions/16762021/cyrillic-symbols-in-sql-code-are-not-correctly-after-insert

    Let us know how it goes for you.

    Thread Starter apopovski

    (@apopovski)

    11 months, 1 week ago

    Thank you very much Leeberty. Can you just please tell me where should I select nvarchar option since there is no option for nvarchar in the data type under column type .

    Thank you

    Alex

    Plugin Contributor Kim L

    (@kimmyx)

    11 months, 1 week ago

    Hi Alex,

    May we know how you’re inserting into the table? Is it from the Data Explorer?

    Thread Starter apopovski

    (@apopovski)

    11 months, 1 week ago

    I will try to answer it since I am still not familiar with everything. I am trying to enter the data via form. I created a form with two tables and there is menu item now to the left below wp data access menu item. In the form I click on one of the tables and I add row . Then I got the following error:

    ERROR: Saving changes to database failed [WordPress database error: Processing the value for the following field failed: imeprezime. The supplied value may be too long or contains invalid data.]

    If I go via explorer and if I add text in Cyrillic I got question marks.

    Regarding the nvarchar I am trying to change that via designer. Please see attached photo.

    Thank you for everything.

    Alex

    Plugin Contributor Kim L

    (@kimmyx)

    11 months, 1 week ago

    Hi Alex,

    Thanks for the screenshot! Can you try changing the collation to utf8_general_ci? See here: https://share.getcloudapp.com/BluzXxX8

    Let us know how it goes!

    Thread Starter apopovski

    (@apopovski)

    11 months ago

    Hello Kim,

    It did not work changing the collation of the table via designer. It did work when I changed the collation of the whole database and tables within.

    Thank you

    Alex

    Plugin Contributor Kim L

    (@kimmyx)

    11 months ago

    Hi Alex,

    Thanks for the update! 🙂

    Let us know if we can help with anything else. 🙂

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Cyrillic support’ is closed to new replies.

Tags