openaccount1
asked on
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
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
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ASKER
Just a follow up on the source where it says MS Access Dbase are in unicode. Thanks.
ASKER
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?
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?
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.