Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL Server 6.5 : Whitespace and é,è,ù,à, ',ö, ... characters

1 view
Skip to first unread message

Damien Deschamps

unread,
Jul 9, 1999, 3:00:00 AM7/9/99
to
Hello,

I'm working with Access 97 and Sql Server 6.5 with Windows NT

When I export my tables from Access 97 to SQL Server 605,
the names of tables and fields of tables which have
whitespace and characters like é, è, à, ... (accentuation)
are replaced by _.
Example : "Table des Numéros" ==> "Table_des_num_eros"

Unfortunately, it's very important for me to keep
the name in the initial state (In the next step, I'm going
to attach the tables to Access)

Can you tell me a mean to keep the whiteSpace and
accents.

Thank you,
Have a good week-end,

Damien.
mailto:damien.d...@bsf.alcatel.fr

Ryszard Pyzanowski

unread,
Jul 9, 1999, 3:00:00 AM7/9/99
to
No problem, after connecting table to MSAccess you can rename connected
table.

Użytkownik Damien Deschamps <Damien.D...@bsf.alcatel.fr> w wiadomooci
do grup dyskusyjnych napisał:37861CDF...@bsf.alcatel.fr...


> Hello,
>
> I'm working with Access 97 and Sql Server 6.5 with Windows NT
>
> When I export my tables from Access 97 to SQL Server 605,
> the names of tables and fields of tables which have

> whitespace and characters like é, č, ŕ, ... (accentuation)

0 new messages