1

Closed

Unicode Problem

description

This Project is great but have a huge problem Please make this to accept Unicode with other type like date and int.at now when write:
SELECT FieldType,dbo.GROUP_CONCAT_D(r.DocID ,' و ') FROM dbo.GroupConcatTestData r GROUP BY FieldType
based on Test.1.BuildTestData.sql demo with 2 loop get this :
Image

thanks for this and i'm waiting for modification.

HGH System MediaSpace
Closed Jun 21, 2014 at 3:54 AM by opcthree

comments

opcthree wrote Jun 21, 2014 at 3:53 AM

The Aggregate Function supports Unicode. This issue is within the SQL statement. You must always let the server know your string-literal contains Unicode characters otherwise it will escape it with a question mark. You do this by placing a capital "N" in front of the leading single-quote in your string literal. Try your query this way:

SELECT FieldType,dbo.GROUP_CONCAT_D(r.DocID ,N' و ') FROM dbo.GroupConcatTestData r GROUP BY FieldType

wrote Jun 21, 2014 at 3:54 AM