|
ccdon
|
|
 Posted: Mon Sep 27, 2004 8:43 am |
|
 |
 |
|
|
Hi,
Anyone know how to search unicode using Ms SQL 2000 and Cold Fusion MX? Thanks a lot!
|
|
|
|
byron
Forum Admin
| Joined: 07 Mar 2004 |
| Posts: 160 |
| Location: Newark, DE, USA |
|
|
| Posted: Wed Sep 29, 2004 10:54 pm |
|
|
|
|
|
You may want to look at doing the search as a stored procedure. I've never done this via a cfquery. I general this should be easier than getting the driver to cooperate.
|
|
|
|
ccdon
|
|
| Posted: Thu Sep 30, 2004 4:44 am |
|
|
|
|
|
Could you please give me an example of that?
Thank you very much!
|
|
|
|
byron
Forum Admin
| Joined: 07 Mar 2004 |
| Posts: 160 |
| Location: Newark, DE, USA |
|
|
| Posted: Thu Sep 30, 2004 1:38 pm |
|
|
|
|
|
I believe all you will have to do is add a N in front of your search string. Which specifies the string as a nchar/nvarchar,ntext data type.
Something like this should work.
select *
from table
where col = N'Åkergatan 24'
|
|
|
|
ccdon
|
|
| Posted: Fri Oct 01, 2004 1:17 am |
|
|
|
|
|
Thank you very much for your help!
|
|
|
