How to Change SQL Select Collate In Qlikview

[Anonymous]

hi

i want change sql collate in qlikview

but get error

[MK_QSL]

Simply use

SQL SELECT "Col_ntext"

FROM Test.dbo.TestCollation;

[Anonymous]

i want change collation in qlikview

my access is read to SQL

Data Type is varchar But Save Unicode Data

[vinieme12]

SQL SELECT "Col_ntext" COLLATE Persion_100_BIN

FROM FROM Test.dbo.TestCollation;

Remove 'as'

[MK_QSL]

Then Remove as ...

as per @Vineeth Pujari

[Anonymous]

The problem is displayed data

SQL Server

Qlikview

Becasue SQL Data Taype Is Varchar

But Persian Data Is Saved

[vinieme12]

Try

SQL SELECT "Col_ntext" COLLATE Persian_100_CS_AI_WS

FROM FROM Test.dbo.TestCollation;

[Anonymous]

Appearance is not correct

Again, the question mark