Hi all, I have a problem doing some sql query with ADS Local and set the location to spanish. The sql is "select * from table where field like '%Ñ%'". I have some collation error with this query but if I run it in ARC, it shows perfect. What do I need to change in my TAdsQuery to make it work ?

Thanks to all.

asked 09 Aug '15, 19:07

lbidi's gravatar image

accept rate: 14%

What is "some collation errror"? Could you please be a bit more precise? Do you have an ADS error code?

(10 Aug '15, 20:30) Jens Mühlenhoff

Even if you don't use Unicode ... Delphi does. You need to ship aicu32.dll and icudt40l.dat along with the Advantage DLLs.


answered 10 Aug '15, 20:59

Joachim%20Duerr's gravatar image

Joachim Duerr
accept rate: 18%

Hi Jens, this is the error I get doing the query. I dont use unicode as far as I know. i have set my tadsquery with both properties ( ADSCHARTYPE and ADSCOLLATION ) with OEM. Thanks for you help.

alt text


answered 10 Aug '15, 20:49

lbidi's gravatar image

accept rate: 14%

You are damm right, Joachim :) . I have the dll file but miss to add the .dat file. Thanks so much.


answered 10 Aug '15, 21:42

lbidi's gravatar image

accept rate: 14%


That's also what I suspected as well. Please include the complete error information in the future that makes it a lot easier to see what's going on.

(11 Aug '15, 15:47) Jens Mühlenhoff
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: 09 Aug '15, 19:07

Seen: 1,921 times

Last updated: 11 Aug '15, 15:47

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.