I apologize if this has been covered ad nauseum, but I didn't see it
in my search.
Basically, in an nvarchar(150) column (called "Phrase" in the below
samples) I store both english text as well as japanese (the table is
for translations). What I'm having trouble with is querying the table
by the NVarChar field.
This works fine:
//////////////
SELECT *
FROM tbl_ShortPhrases
WHERE Phrase = 'Home'
//////////////
But when I try with japanese, nothing is returned:
/////////////
SELECT *
FROM tbl_ShortPhrases
WHERE Phrase = '再価格'
/////////////
I thought that the problem might be a conversion issue, so I tried the
following with no success:
/////////////
SELECT *
FROM tbl_ShortPhrases
WHERE Phrase = CONVERT(NVARCHAR, '再価格')
/////////////
Any help you can offer is appreciated!
Thanks,
Seth Rowe [MVP]
