Page 1 of 1
Query plan not transliterated?
Posted: Tue 27 Feb 2018 13:28
by upscene
Hi,
It seems a query plan using special characters isn't automatically transliterated between charsets, is this correct?
With regards,
Martijn Tonies
Re: Query plan not transliterated?
Posted: Wed 28 Feb 2018 14:56
by ViktorV
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.
Re: Query plan not transliterated?
Posted: Wed 28 Feb 2018 15:21
by upscene
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
Re: Query plan not transliterated?
Posted: Thu 01 Mar 2018 16:54
by ViktorV
Thank you for the information. We have reproduced the problem and it will be fixed in the next build.