Results 1 to 11 of 11
  1. #1
    Stanislavnba is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2019
    Posts
    12

    cant search in Cyrillic

    Hello, Ive just migrated my database to SQL.
    And everything seems to work just fine, but I have this problem. I live in Bulgaria, and most of my DB data is in Cyrillic.
    When I try to search by Customer Name in Access , I cant.


    When I go to SSMS , and do a query

    SELECT * FROM PopulationInfo WHERE [First Name] LIKE N'Мария' ORDER BY ClientCode

    it works.
    Problem is I cant enter this code in Access Query.
    It says syntax error , missing operator.
    Can anybody help?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Welcome to the forum.
    I do not have any experience with cyrillic. I found this link via Google that may help.
    You may also find some articles/videos re settings for code page or, since you are in Bulgaria, some research into
    MS Access with non-Roman languages.
    Here is a link to an article on Bytes re multi-lingual database
    that may give some insight, but there is some discussion on parts of the sample. You may also search for MS Access internationalization. Here is one link I found via Google.
    Good luck. Let us know if you find a solution/example.

  3. #3
    Stanislavnba is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2019
    Posts
    12
    Sorry non of this is helpful.
    All of this solve problems with viewing and storing data in different types.
    I dont have a problem with that.
    My DB works just fine with Cyrillic , when it comes ot updating data, adding new rows or displaying data.
    Even in Access when I search a table by a criteria that is not Cyrillic it works just fine and it shows the Cyrillic data also fine.
    The only problem is when my Query searches for a field in cyrillic., like names of customers.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    cross posted at https://access-programmers.co.uk/for...44#post1633644

    Sorry that the linked info was not helpful.
    Since there seems to be no examples of MS Access with non-Roman languages in the Access Knowledge Base ,
    perhaps you could post a copy of your database in the Sample Databases area in zip format. Remove anything personal/confidential. It is a subject that arises from time to time, but there is no (or very few) examples to reference.


    I just found another link that may be helpful to you.
    https://bytes.com/topic/access/answe...tring-cyrillic

    Good luck.

  5. #5
    Stanislavnba is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2019
    Posts
    12
    This problem only occurs when the BE is on an SQL server.
    If I split the DB on an access BE it will work just fine. Or If I dont split the DB at all.
    So Its pretty hard for me to just send you the DB, even If I do , I cant give you access to the SQL server.

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    My thought was to have an MS Access database that handled Cyrillic. No need for SQL server. All in one database (not split) would be fine as an example. Only needs a few records for demonstration purposes.

  7. #7
    Stanislavnba is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2019
    Posts
    12
    Here is the link to the file.
    open it with Shift +
    cause I have disabled the tables and menu on startup and I coulndt find how to disabled it.
    https://ufile.io/1ifqt7sj

  8. #8
    accesstos's Avatar
    accesstos is offline Expert
    Windows XP Access 2007
    Join Date
    Dec 2018
    Location
    Greece
    Posts
    551
    Quote Originally Posted by Stanislavnba View Post
    open it with Shift +
    cause I have disabled the tables and menu on startup and I coulndt find how to disabled it.
    You have uncheck the "Display Navigation Pane" of "Current Database" in "Access Options".

    Nothing wrong happens in the sample database.
    The query
    Code:
     
    SELECT District.Id, District.District
    FROM District
    WHERE (((District.District)="Мараша"));
    pulls a record with id 4.

  9. #9
    Stanislavnba is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2019
    Posts
    12
    Quote Originally Posted by accesstos View Post
    You have uncheck the "Display Navigation Pane" of "Current Database" in "Access Options".

    Nothing wrong happens in the sample database.
    The query
    Code:
     
    SELECT District.Id, District.District
    FROM District
    WHERE (((District.District)="Мараша"));
    pulls a record with id 4.
    1. You should be searching in the PopulationInfo table. for client name.
    2. The sample DB works just fine. The problem occurs after I migrate to SQL.

  10. #10
    accesstos's Avatar
    accesstos is offline Expert
    Windows XP Access 2007
    Join Date
    Dec 2018
    Location
    Greece
    Posts
    551
    In Access I am taking the correct results with the "PopulationInfo" table also.
    It seems to be something with your database Collation settings in SQL SERVER.
    Unfortunately, at this moment, I can't give a try because, for some reason, I can't start my SSMS.
    Maybe this discussion helps you:
    https://stackoverflow.com/questions/...aracter-in-sql

  11. #11
    Stanislavnba is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2019
    Posts
    12
    Quote Originally Posted by accesstos View Post
    In Access I am taking the correct results with the "PopulationInfo" table also.
    It seems to be something with your database Collation settings in SQL SERVER.
    Unfortunately, at this moment, I can't give a try because, for some reason, I can't start my SSMS.
    Maybe this discussion helps you:
    https://stackoverflow.com/questions/...aracter-in-sql
    that was the 1st thing I thought of. I tried making a new DB with different Collation, but I dont know which one I should use. I used a cyrrilic one and it than both the latin search and cyrillic search didint work

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 08-21-2018, 03:11 PM
  2. Replies: 3
    Last Post: 09-12-2016, 11:49 AM
  3. Replies: 1
    Last Post: 03-26-2015, 11:08 AM
  4. Replies: 3
    Last Post: 01-04-2015, 06:09 PM
  5. Problem with cyrillic objects
    By ttitto in forum Programming
    Replies: 0
    Last Post: 07-05-2010, 12:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums