I have a DBF where the text fields are formatted in utf-8. When I run "alter table....", the content is changed and no longer proper utf-8. How should I set AdsQuery1.AdsTableOptions.AdsCharType to make it work ?

Delphi XE4 and ADS 11.10, 32 bit.

asked 11 Sep '14, 11:39

Uffe%20K's gravatar image

Uffe K
accept rate: 0%

It sounds like you are using a character field. Is this correct?

I would recommend using the Unicode field types such as nchar, nvarchar or nmemo. You can still stick with the DBF format but you will need to use the VFP table type rather than the CDX table type.


answered 11 Sep '14, 13:36

Edgar%20Sherman's gravatar image

Edgar Sherman
accept rate: 25%

DBF format is fixed (part of a SHP file), not something I can change. It is a normal character field, except the content is utf-8.

(11 Sep '14, 13:40) Uffe K
Your answer to the original question.
If responding to a request for additional information, please edit the question or use the comment functionality.
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 11 Sep '14, 11:39

Seen: 1,625 times

Last updated: 11 Sep '14, 13:40

Advantage Developer Zone Contact Us Privacy Policy Copyright Info

Powered by Advantage Database Server and OSQA
Disclaimer: Opinions expressed here are those of the poster and do not necessarily reflect the views of the company.