"Mario Cappa" <mario.cappa@arcott.it> wrote in message
news:cguq57$vv4$1@news.ngi.it...
> 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
>
>

"Mario Cappa" <mario.cappa@arcott.it> wrote in message
news:cgvh2s$848$1@news.ngi.it...
> 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@att.net> ha scritto nel messaggio
> news:ezjkYZojEHA.3724@TK2MSFTNGP11.phx.gbl...
> > 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@arcott.it> wrote in message
> > news:cguq57$vv4$1@news.ngi.it...
> > > 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@arcott.it> wrote in message
> news:cguq57$vv4$1@news.ngi.it...
> > 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
> >
> >
>
>

> 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@arcott.it> wrote in message
> news:cgvh2s$848$1@news.ngi.it...
> > 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@att.net> ha scritto nel messaggio
> > news:ezjkYZojEHA.3724@TK2MSFTNGP11.phx.gbl...
> > > 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@arcott.it> wrote in message
> > > news:cguq57$vv4$1@news.ngi.it...
> > > > 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
> > > >
> > > >
> > >
> > >
> >
> >
>
>

"Mario Cappa" <mario.cappa@arcott.it> wrote in message
news:ezhKiuqjEHA.704@TK2MSFTNGP09.phx.gbl...
> 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@gmail.com> ha scritto nel messaggio
> news:Our0dmqjEHA.556@tk2msftngp13.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@arcott.it> wrote in message
> > news:cgvh2s$848$1@news.ngi.it...
> > > 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@att.net> ha scritto nel messaggio
> > > news:ezjkYZojEHA.3724@TK2MSFTNGP11.phx.gbl...
> > > > 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@arcott.it> wrote in message
> > > > news:cguq57$vv4$1@news.ngi.it...
> > > > > 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
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

> 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@arcott.it> wrote in message
> news:ezhKiuqjEHA.704@TK2MSFTNGP09.phx.gbl...
> > 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@gmail.com> ha scritto nel messaggio
> > news:Our0dmqjEHA.556@tk2msftngp13.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@arcott.it> wrote in message
> > > news:cgvh2s$848$1@news.ngi.it...
> > > > 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@att.net> ha scritto nel messaggio
> > > > news:ezjkYZojEHA.3724@TK2MSFTNGP11.phx.gbl...
> > > > > 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@arcott.it> wrote in message
> > > > > news:cguq57$vv4$1@news.ngi.it...
> > > > > > 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
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>