Cyrillic characters in Access table

Posted on 2004-11-24
Last Modified: 2010-04-05

I'm using Access-based ADO tables in my Delphi application. Some fields can contain Russian (cyrillic) characters. When I run it on a computer with Russian default system locale, everything is OK. But when the default system locale is different (English), all the cyrillic characters turn into question marks. Is there any way to provide that they are treated properly under any system settings?

Vadim Smolensky,
Saint-Petersburg, Russia
Question by:VSmolensky
    LVL 13

    Expert Comment

    you need to have that language added to the "Language settings for the system"

    even if that is not your default language

    your default language can be english, but you need to add Cyrillic to the list

    open Regional Options in the Control panel, General Tab

    at the bottom there's a list called ""Language settings for the system"", check Cyrillic

    Author Comment

    No, it's not my case.
    I haven't mentioned that this problem arises only when I run my application under Windows XP. In your post, you definetely meant another version (probably 2000). There's no "Language settings for the system" in XP but there's a list called "Code page conversion tables". On my computer, all the cyrillic checkboxes in this list are checked. And all the cyrillic letters appear properly - except for those extracted from the Access database. Therefore, I think it's a problem of Access rather than the whole system. Under Windows 2000, this doesn't happen.
    LVL 13

    Expert Comment

    in Windows XP would be "Regional and language options" in the control panel

    then in the language TAB, suplemental language support check both boxes, that might fix the problem, seems like in XP most languages are preinstalled and you just have options for right-to-left languages and east asian languages

    Author Comment

    What are you talking about? Russian ISN'T a right-to-left language! It's a Indoeuropean language with just different letters. And, again, these letters look absolutely OK except those taken from Access database.
    LVL 13

    Accepted Solution

    right, I didn't say that...

    if it seems to be related only to ACCESS you might want to try posting in a different category

    I found this in the MSACCESS category, it was accepted as the correct answer:
    " Access doesn't have a crylic option for record storage.
    It must be stored as a memo field or text etc...."

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
    Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now