Export Access table into another DBMSpreserving Unicode characters?

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 :)

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" <dreamers_spa@yahoo.it> wrote in message
news:1b641cf1.0402040047.c1d0c63@posting.google.co m...[color=blue]
> 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 :)[/color]

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]" <michkap@online.microsoft.com> wrote in message news:<4021105b$1@news.microsoft.com>...[color=blue]
> 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" <dreamers_spa@yahoo.it> wrote in message
> news:1b641cf1.0402040047.c1d0c63@posting.google.co m...[color=green]
> > 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 :)[/color][/color]

In message <1b641cf1.0402040047.c1d0c63@posting.google.com> , JJ
<dreamers_spa@yahoo.it> writes[color=blue]
>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 ;)[/color]

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.

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" <dreamers_spa@yahoo.it> wrote in message
news:1b641cf1.0402050118.40f17cd@posting.google.co m...[color=blue]
> 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]" <michkap@online.microsoft.com> wrote in[/color]
message news:<4021105b$1@news.microsoft.com>...[color=blue][color=green]
> > 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" <dreamers_spa@yahoo.it> wrote in message
> > news:1b641cf1.0402040047.c1d0c63@posting.google.co m...[color=darkred]
> > > 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 :)[/color][/color][/color]