?
Solved

Cyrillic characters in Access table

Posted on 2004-11-24
5
Medium Priority
?
722 Views
Last Modified: 2010-04-05
Hello,

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
0
Comment
Question by:VSmolensky
  • 3
  • 2
5 Comments
 
LVL 13

Expert Comment

by:BlackTigerX
ID: 12670865
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
0
 

Author Comment

by:VSmolensky
ID: 12672553
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.
0
 
LVL 13

Expert Comment

by:BlackTigerX
ID: 12677328
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
0
 

Author Comment

by:VSmolensky
ID: 12680578
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.
0
 
LVL 13

Accepted Solution

by:
BlackTigerX earned 250 total points
ID: 12697554
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...."

http://www.experts-exchange.com/Databases/MS_Access/Q_21096766.html?query=cyrillic&topics=39
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses
Course of the Month14 days, 23 hours left to enroll

839 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