I need to import any paradox tables in SQL Server 2000, but i'm having
troubles with char conversion:
Does anyone have any idea about why all accented chars in source paradox
table turn into other chars in the new SQL Table:

à in paradox turns into Ó in SQL
è " " " " Þ " "
ì " " " " ý " "
ò " " " " ? " "
ù " " " " ¨ " "
é " " " " Ú " "

Any hints on what should i trim to correcty this behavior?

Thanks

Mario

you need to pick another collation. What collation is DTS automatically
selecting? It looks like you should be using French.

--
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html


"Mario Cappa" <mario.cappa (AT) arcott (DOT) it> wrote

Hello Hilary,
i couldn't find a way to see which collation is my DTS automatically
selecting, i can only imagine it's Latin General since i've changed nothing
in default settings and i'm in italy.
Anyway it looks more like it's a problem with settings on OEM/ANSI
translation settings, but even in this case i couldn't find a way to set
such a setting.

Mario Cappa

"Hilary Cotter" <hilaryk (AT) att (DOT) net> ha scritto nel messaggio
news:ezjkYZojEHA.3724 (AT) TK2MSFTNGP11 (DOT) phx.gbl...

how are you importing the table? Is this through a DSN? If so what collation
sequence are you using. I think you should be using ANSI.

Also check the collation of the table which DTS created. Do a sp_help
TableName using Query Analyzer.

--
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html


"Mario Cappa" <mario.cappa (AT) arcott (DOT) it> wrote

I'm using ANSI on SQL but i'm not sure the setting is the same on Paradox
table
Table is imported through Paradox 5.x OLE DB drivers and collation sequence
results as Latin1_General_CI_AS


"Hilary Cotter" <hilary.cotter (AT) gmail (DOT) com> ha scritto nel messaggio
news:Our0dmqjEHA.556 (AT) tk2msftngp13 (DOT) phx.gbl...

how about trying the international setting on your dsn?

--
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html


"Mario Cappa" <mario.cappa (AT) arcott (DOT) it> wrote

I solved my problems after i could find paradox tables native language and
change it to Western Europe ANSI

Thanky you for your suggestions

Mario

"Hilary Cotter" <hilary.cotter (AT) gmail (DOT) com> ha scritto nel messaggio
news:%23HjsoMwjEHA.2340 (AT) TK2MSFTNGP11 (DOT) phx.gbl...