Unanswered: Unknow Char Values When Extracting Via ODBC Driver for Pervasive SQL 7
I have been tasked by my work to extract all the data from our PSQL DB to insert into a new system, the current application that uses this database was installed before I joined and all skills with this software has been lost as the people who installed and maintained it have left the company, so I was given this task.
Now I found what I believe to be a custom application that uses the current odbc connectivity to extract the data and this works fine for the smaller table and delimits the field with the following symbol: ¬ now I can use this for the smaller table but one table is too large for this custom Application(Near 2 Million Records) which I have tried to extract in batches by using an index and setting ranges with does not work, the extract starts at BOF everytime
I need to extract these records but I keep getting unknown char symbols in the view and extract but using this custom Application I get numbers and fullstops(ie: 22.214.171.124.2)
Does Anybody have any suguestions.
Sorry about the lack of actual details regarding the tables this is due to the nature of my work
Thanks in Advance
Web & Systems Developer
Last edited by HackerNeo; 09-29-05 at 12:01.
Reason: Adding Better Explaination
I understand your viewpoint it was the point I took until certain columns stop showing values like 126.96.36.199 and started to show unknown char symbol instead(begintransaction, space and end transaction chr codes) are displayed
but this only happens when using Pervasive SQL ODBC Drivers.
if you could please advise as so ideas that wouuld be greatful