git.net

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: does calcite support chinese?


Yes.

By the way, I did not run

  select ‘привет’ = ‘привет'

because boolean expressions in the SELECT clause is non-standard. (Sad but true.) The statement I actually ran on MSSql was

  select ‘привет'

This comes out as question marks, but

  select N‘привет'

works as intended. The ’N’ has to be upper-case. For a while I tried

  select n‘привет'

but I kept getting errors.

Julian


> On Nov 7, 2018, at 11:33 AM, Vladimir Sitnikov <sitnikov.vladimir@xxxxxxxxx> wrote:
> 
>> You need to prefix literals with ’N’, like this: N’привет'
> 
> For the reference "Sql Server" silently converts characters to question
> marks, so the following yields T:
> select case when 'привет'='??????' then 'T' else 'F' end
> 
> Vladimir