Board index » delphi » How to import CSV file containing double byte characters

How to import CSV file containing double byte characters

Hi,

    I am trying to import a CSV text file using Schema file as described
in the the '2844:Using The ASCII driver with comma-delimited file'. All
is fine except for fields that contains double-byte characters(ie.
chinese double byte character). Is there any way I can fixed this
problem?

Thanks

Michael

 

Re:How to import CSV file containing double byte characters


Quote
michael wrote:

> Hi,

>     I am trying to import a CSV text file using Schema file as described
> in the the '2844:Using The ASCII driver with comma-delimited file'. All
> is fine except for fields that contains double-byte characters(ie.
> chinese double byte character). Is there any way I can fixed this
> problem?

> Thanks

> Michael

You had more luck than I did - my attempt keeps crashing my system.

Were you able to open the .csv file in the DB Desktop? I cannot.

As for your double byte problem - looks like you need unicode, which does not
appear to be supported bsed on 2844. Try speicfying it as a smallint, then cast
it to a widechar in a calc field.

--
bob
myName = 'bobmackey';
myISP = 'annapolis.net';
myaddress := myName + '@' + myISP;

Other Threads