I'm attempting to read a standard ASCII csv file via this command...
SELECT * FROM CSVREAD('file.csv',data1|data2, 'ASCII', '|', NULL,
NULL, 'NULL');
When I do so, I always seem to get data that has a bad char every
other btye.
For example:
744996 shows up as
7�4�4�9�9�6
My original file is an ASCII file...I'm struggling with why this isn't
working.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---