NEW SEND WITH UTF-8
--------------------------------------------------------------------------------------------

Hi,

I have a problem with a request concerning chineese data on a nText field...
Here is a sample:

TABLE : T
FIELD : TXT as nText

I insert this value on my table : ? [???] ???????????

Now i'd like to query my table to retrieve rows containing an exact match to
my only line

SELECT * FROM T WHERE TXT LIKE '? [[]???] ???????????'

as specified in MSDN documentation i have to replace the caracter [ to [ [ ]
and let the caracter ] as normal
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_la-l
z_115x.asp)

This request doesn't return me any result. i tried a lot of variations to
retrieve my data (space between [, ] and ]; replace ] by []] ...) but
nothing's working

However one thing is working > Convert my TXT field from nText to varchar :
   SELECT * FROM T WHERE CONVERT(varchar(8000),TXT) LIKE '? [[]???]
???????????'
The query return the good answer

Another thing > Convert myTXT field from nText to nvarchar :
   SELECT * FROM T WHERE CONVERT(nvarchar(4000),TXT) LIKE '? [[]???]
???????????'
This query don't return any result !

If someone have an idea about this problem, i'll be really happy to read him
;-)

PS: I'm Working on SQL SERVER 2005.

Thanks
Guillaume D.

NEW SEND WITH UTF-8
--------------------------------------------------------------------------------------------
Hi,

I have a problem with a request concerning chineese data on a nText field...
Here is a sample:

TABLE : T
FIELD : TXT as nText

I insert this value on my table : ? [???] ???????????

Now i'd like to query my table to retrieve rows containing an exact match to
my only line

SELECT * FROM T WHERE TXT LIKE '? [[]???] ???????????'

as specified in MSDN documentation i have to replace the caracter [ to [ [ ]
and let the caracter ] as normal
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_la-l
z_115x.asp)

This request doesn't return me any result. i tried a lot of variations to
retrieve my data (space between [, ] and ]; replace ] by []] ...) but
nothing's working

However one thing is working > Convert my TXT field from nText to varchar :
   SELECT * FROM T WHERE CONVERT(varchar(8000),TXT) LIKE '? [[]???]
???????????'
The query return the good answer

Another thing > Convert myTXT field from nText to nvarchar :
   SELECT * FROM T WHERE CONVERT(nvarchar(4000),TXT) LIKE '? [[]???]
???????????'
This query don't return any result !

If someone have an idea about this problem, i'll be really happy to read him
;-)

PS: I'm Working on SQL SERVER 2005.

Thanks
Guillaume D.

Try this (untested):
SELECT * FROM T WHERE TXT LIKE N'? [[]???] ???????????'

ML

---
http://milambda.blogspot.com/