468,117 Members | 1,576 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,117 developers. It's quick & easy.

Export Access table into another DBMSpreserving Unicode characters?

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
4 2790
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
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
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
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.

Similar topics

4 posts views Thread by Anthony Cuttitta Jr. | last post: by
3 posts views Thread by nologin | last post: by
1 post views Thread by watto | last post: by
1 post views Thread by tong_su | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.