Devart Forums

Posted: **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

Posted: **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.

Posted: **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

Posted: **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.

Devart Forums

Query plan not transliterated?

Query plan not transliterated?

Re: Query plan not transliterated?

Re: Query plan not transliterated?

Re: Query plan not transliterated?