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?

  • ,Are you getting any collation error. – Md Haidar Ali Khan Feb 16 '16 at 10:23
  • I'm not, select works fine without any errors. – Przemyslaw Wojda Feb 16 '16 at 10:28
  • A quick search suggests you may need to specify (in OPENROWSET) the code page the data in your DBF files are currently using. For details see this question at MSDN Forums. – Andriy M Feb 16 '16 at 10:28
  • Thank you, Andriy. Any idea how to insert CharacterSet statement into this query: SELECT * FROM OPENROWSET('VFPOLEDB','FilePath\FileName.DBF';'';'','SELECT * FROM FileName') – Przemyslaw Wojda Feb 16 '16 at 10:51
  • No idea, sorry. And it doesn't help that the driver is 32-bit while my server instance is 64-bit, or I would've played around with OPENROWSET arguments to try and find a way (although I must say the syntax that goes with VFPOLEDB is sooooo unintuitive, to put it mildly). – Andriy M Feb 17 '16 at 10:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.