Recently, I play with ISAM again. This time I need to get data from Paradox. It was really a paradox!
I guess the vendor's using the latest version, as I got some Unicode data returned.
However, I got some corrupted data (probably returning doube-byte text or ANSI as Unicode/nvarchar) ... and it is a foreign key.
The table returns a Unicode column to me but storing invalid characters (it was simplified-Chinese text).
It's pretty hilarious.
Now I can't join the tables with standard SQL scripts.
I've started to study the encoding problem...that's quite boring.
BTW, I need to overcome it asap. OT is expected.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment