By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

Export Access table into another DBMSpreserving Unicode characters?

P: n/a
JJ
Hi,

usually, I'm not using MS servers, but I have a big problem with a
Access table.

I should create a web application for a Historical Dipartment.
They have created a populated a Access database using unicode
compression field (for ancient language).

I would like to export this table into MySQL o Postgres, but it's
impossible because when I export this table in a .txt o cvs format the
unicode charaters have been "destroyed" for memory allocation problems
(cause Access use a compression tool for unicode fields).
Also with professional tools for dump Access to another DBMS.

I would to know if using a MS SQL server I can skip this problem cause
both MSQLserver both Access are Microsoft product. But I prefer,
sincerly. a method for export th unicode field intactly cause I love
MySQL ;)

Thank you :)
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Does mysql even support Unicode? If they do, then find a format they can
accept which has Unicode in it.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
"JJ" <dr**********@yahoo.it> wrote in message
news:1b*************************@posting.google.co m...
Hi,

usually, I'm not using MS servers, but I have a big problem with a
Access table.

I should create a web application for a Historical Dipartment.
They have created a populated a Access database using unicode
compression field (for ancient language).

I would like to export this table into MySQL o Postgres, but it's
impossible because when I export this table in a .txt o cvs format the
unicode charaters have been "destroyed" for memory allocation problems
(cause Access use a compression tool for unicode fields).
Also with professional tools for dump Access to another DBMS.

I would to know if using a MS SQL server I can skip this problem cause
both MSQLserver both Access are Microsoft product. But I prefer,
sincerly. a method for export th unicode field intactly cause I love
MySQL ;)

Thank you :)

Nov 12 '05 #2

P: n/a
JJ
Sure. MYSQL 4.1 supports Unicode, Unicode2 and utf-8.

I also try to export this access table into a txt file and then into a
Oracle DB... there is the same problem with MySQL:(

JJ

"Michael \(michka\) Kaplan [MS]" <mi*****@online.microsoft.com> wrote in message news:<40********@news.microsoft.com>...
Does mysql even support Unicode? If they do, then find a format they can
accept which has Unicode in it.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
"JJ" <dr**********@yahoo.it> wrote in message
news:1b*************************@posting.google.co m...
Hi,

usually, I'm not using MS servers, but I have a big problem with a
Access table.

I should create a web application for a Historical Dipartment.
They have created a populated a Access database using unicode
compression field (for ancient language).

I would like to export this table into MySQL o Postgres, but it's
impossible because when I export this table in a .txt o cvs format the
unicode charaters have been "destroyed" for memory allocation problems
(cause Access use a compression tool for unicode fields).
Also with professional tools for dump Access to another DBMS.

I would to know if using a MS SQL server I can skip this problem cause
both MSQLserver both Access are Microsoft product. But I prefer,
sincerly. a method for export th unicode field intactly cause I love
MySQL ;)

Thank you :)

Nov 12 '05 #3

P: n/a
In message <1b*************************@posting.google.com> , JJ
<dr**********@yahoo.it> writes
Hi,

usually, I'm not using MS servers, but I have a big problem with a
Access table.

I should create a web application for a Historical Dipartment.
They have created a populated a Access database using unicode
compression field (for ancient language).

I would like to export this table into MySQL o Postgres, but it's
impossible because when I export this table in a .txt o cvs format the
unicode charaters have been "destroyed" for memory allocation problems
(cause Access use a compression tool for unicode fields).
Also with professional tools for dump Access to another DBMS.

I would to know if using a MS SQL server I can skip this problem cause
both MSQLserver both Access are Microsoft product. But I prefer,
sincerly. a method for export th unicode field intactly cause I love
MySQL ;)


Create the table structure in MySQL and attach it to the Access database
using ODBC. Create an append query in Access and append all of the
existing Access table to the empty MySQL table.

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

Nov 12 '05 #4

P: n/a
You can use the wizard to SPECIFY the way to export the text. If you do
this, then everything will work.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

"JJ" <dr**********@yahoo.it> wrote in message
news:1b*************************@posting.google.co m...
Sure. MYSQL 4.1 supports Unicode, Unicode2 and utf-8.

I also try to export this access table into a txt file and then into a
Oracle DB... there is the same problem with MySQL:(

JJ

"Michael \(michka\) Kaplan [MS]" <mi*****@online.microsoft.com> wrote in

message news:<40********@news.microsoft.com>...
Does mysql even support Unicode? If they do, then find a format they can
accept which has Unicode in it.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
"JJ" <dr**********@yahoo.it> wrote in message
news:1b*************************@posting.google.co m...
Hi,

usually, I'm not using MS servers, but I have a big problem with a
Access table.

I should create a web application for a Historical Dipartment.
They have created a populated a Access database using unicode
compression field (for ancient language).

I would like to export this table into MySQL o Postgres, but it's
impossible because when I export this table in a .txt o cvs format the
unicode charaters have been "destroyed" for memory allocation problems
(cause Access use a compression tool for unicode fields).
Also with professional tools for dump Access to another DBMS.

I would to know if using a MS SQL server I can skip this problem cause
both MSQLserver both Access are Microsoft product. But I prefer,
sincerly. a method for export th unicode field intactly cause I love
MySQL ;)

Thank you :)

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.