Query plan not transliterated?

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
upscene
Posts: 282
Joined: Thu 19 Oct 2006 08:13

Query plan not transliterated?

Post by upscene » Tue 27 Feb 2018 13:28

Hi,

It seems a query plan using special characters isn't automatically transliterated between charsets, is this correct?

With regards,

Martijn Tonies

ViktorV
Devart Team
Posts: 2807
Joined: Wed 30 Jul 2014 07:16

Re: Query plan not transliterated?

Post by ViktorV » Wed 28 Feb 2018 14:56

Please describe your question in more detail. And even better, if it does not complicate you, to better understand the question and an early reply to it, please send a small sample to demonstrate the issue to us via form e-support: https://www.devart.com/company/contactform.html.

upscene
Posts: 282
Joined: Thu 19 Oct 2006 08:13

Re: Query plan not transliterated?

Post by upscene » Wed 28 Feb 2018 15:21

ViktorV wrote:Please describe your question in more detail. And even better, if it does not complicate you, to better understand the question and an early reply to it, please send a small sample to demonstrate the issue to us via form e-support: https://www.devart.com/company/contactform.html.
It's easy to reproduce - use a UTF8 database, set 'use unicode client' to true.

Code: Select all

CREATE TABLE "ULVSUNDAVÄGEN" 
(
  "ULVSUNDAVÄGEN"              INTEGER         NOT NULL,
 CONSTRAINT "PK_ULVSUNDAVÄGEN" PRIMARY KEY ("ULVSUNDAVÄGEN")
);
Take a look at the plan for this query:

Code: Select all

select
  *
from
  "ULVSUNDAVÄGEN"  where "ULVSUNDAVÄGEN" =1

ViktorV
Devart Team
Posts: 2807
Joined: Wed 30 Jul 2014 07:16

Re: Query plan not transliterated?

Post by ViktorV » Thu 01 Mar 2018 16:54

Thank you for the information. We have reproduced the problem and it will be fixed in the next build.

Post Reply