Cyrillic characters problem

3 posts, 0 answers
  1. Martin Gschleiner
    Martin Gschleiner avatar
    3 posts
    Member since:
    Nov 2009

    Posted 13 May 2014 Link to this post


    We have  an MS SQL Server 2005 database, collation is Latin1_General_CI_AS. Up to now only latin characters have been persisted in the DB tables, but recently a requirement to also store strings in cyrillic charsets has come up.  

    When updating an nvarchar field with cyrillic characters from within SSMS it works as expected - cyrillic characters are properly persisted. When updating the same field through Data Access with cyrillic characters what ends up being stored in the DB is a string consisting of question marks - '???????'.

    If I was to write an insert/update statement manually (without the ORM) I would use the N qualifier: i.e. INSERT INTO myTable (myNvarCharField) VALUES (N'Поиск').

    We are using an ancient version of Data Access - I realize this version is way out of date. Unfortunately, an update to a more recent version is not easily possible for several reasons.

    I'd really appreciate your help on this problem. Can I use our Open Access version to persist cyrillic text? Is there a recommended workaround if not?

  2. Martin Gschleiner
    Martin Gschleiner avatar
    3 posts
    Member since:
    Nov 2009

    Posted 14 May 2014 in reply to Martin Gschleiner Link to this post

    Problem solved. Apparently only affected fields of type NVARCHAR(max) are affected. Changing the field type to i.e. NVARCHAR(4000) fixed the issue.
  3. DevCraft banner
  4. Kristian Nikolov
    Kristian Nikolov avatar
    206 posts

    Posted 14 May 2014 Link to this post

    Hi Martin,

    We are glad you have resolved the situation. Do not hesitate to post in our forums again should you have additional questions or need help.

    Kristian Nikolov
    OpenAccess ORM is now Telerik Data Access. For more information on the new names, please, check out the Telerik Product Map.
Back to Top