Import from dbf - collation

2 votes

0 answers

442 views

sql-server-2012 collation openrowset visual-foxpro

                          I select data from dbf files through OPENROWSET Visual FoxPro OLEDB.  
Despite forcing collation on columns (e.g. SELECT name COLLATE Polish_CI_AS FROM Employees) the polish specific characters keep being different characters.

Due to the data model complexity, nested replace statements are not desired.  
Any idea how to fix it?
                        

Asked by Przemyslaw Wojda (303 rep)

Feb 16, 2016, 10:15 AM
Last activity: Feb 16, 2016, 10:34 AM

Import from dbf - collation

Related Questions