[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2203
  • Last Modified:

MS Access Question: Determine Dbase encoding or Charset in MS Access 2003, 2007, and 2010

Hi,
 
We currently have an MS access dbase however we would like to know:

1. How to determine the charset or encoding of our MS Access Dbase?
2. How to convert our MS Access dbase to UTF8?

We are using the following MS Access.

1. Microsoft Office Access 2003 (11.8321.8341) SP3
2. Microsoft Office Access 2007 (12.0.6535.5005) SP2 MSO (12.0.6562.5003)
3. Microsoft Office Access 2010 (12.0.6423.1000)

And we would like to know how to do the actions mentioned above on all 3 versions of MS Access.

The reason is because we store some website data in our MS access database and copy them to directly to our webpages by:

a. copying the data from our database via copy-paste command in windows.
b. automated script to extracts the data from our database and copy the data to our webpages.
c. Exporting data to csv file and extracts the data from our csv file to the webpages.

Best Regards,
Openaccount
0
openaccount1
Asked:
openaccount1
  • 4
  • 2
1 Solution
 
datAdrenalineCommented:
Your question is a bit disconnected.  The data of an MDB or ACCDB is stored in binary format.  Text based data is stored in unicode format (can be compressed).  But .. you really don't look at the the database file to determine the encoding.  You have to output your data to a human readable form (ie: a CSV).  So, when you are requesting output from that binary data your encoding is determined from the object generating the output (If I understand correctly this process correctly :) ).  

So for ...
<a. copying the data from our database via copy-paste command in windows.>

Are you copying data from a Datasheet view? and what are you pasting the data into?

<b. automated script to extracts the data from our database and copy the data to our webpages.>

How are you getting the data? Through ADO recordsets? Through ADO.Net DataTable's?

<c. Exporting data to csv file and extracts the data from our csv file to the webpages. >

How are you getting the data? Through ADO recordsets? Through ADO.Net DataTable's? Also, how are you writing that data to the CSV file?

----

By the way, are you experiencing issues with what you are trying to do? If so, please describe the issue you think knowing how to force UTF-8 will solve.


0
 
openaccount1Author Commented:
Hi datAdrenaline,

Here are the answers to your questions.

<a. copying the data from our database via copy-paste command in windows.>
Are you copying data from a Datasheet view? and what are you pasting the data into?

ANSWER: We are copying from form view.

<b. automated script to extracts the data from our database and copy the data to our webpages.>
How are you getting the data? Through ADO recordsets? Through ADO.Net DataTable's?

ANSWER: We are copying using ADO recordsets.

<c. Exporting data to csv file and extracts the data from our csv file to the webpages. >

How are you getting the data? Through ADO recordsets? Through ADO.Net DataTable's? Also, how are you writing that data to the CSV file?

ANSWER: We actually export the information to CSV Manually from the dbase and then use PHP functions.

Note that I am not the programmer so all we really want is to find out if data in the MS access dbase are in UTF8 and will there be any problem using the above methods when copying data to HTML pages e.g. a conflict on encoding? Because currently we have our pages in UTF8 and we do not want to contaminate the pages with nonUTF8 characters.
0
 
datAdrenalineCommented:
>> Note that I am not the programmer so all we really want is to find out if data in the MS access dbase are in UTF8 and will there be any problem using the above methods when copying data to HTML pages e.g. a conflict on encoding? <<

You should not run into any issues.  We use the .GetString method often in order to fill in information on web pages.  I am unsure as to the encodeing of the webpage, likely UTF-8, and Access data is Unicode format (DBCS), and as far as I know, our web developer does not do anything fancy with the encoding upon getting the data.
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
openaccount1Author Commented:
So in short MS Access data in in Unicode? Can I ask for a source where we can get the information that MS Access data is in unicode format.
0
 
openaccount1Author Commented:
Just a follow up on the source where it says MS Access Dbase are in unicode. Thanks.
0
 
openaccount1Author Commented:
According to Microsoft, not all MS Office are in DBCS:

Source: http://msdn.microsoft.com/en-us/library/aa261360%28v=VS.60%29.aspx

Which states:
"DBCS is used in Microsoft Windows systems that are distributed in most parts of Asia. It provides support for many different East Asian language alphabets, such as Chinese, Japanese, and Korean."

Anyone who knows how to determine if an MS access in in DBCS format?
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now