Russian texts into MS SQL-Server

[blanked-face]

I'm programming a formular, which should be used by many countries and by the
input of the russian texts there seems to be a problem. I imported some russian
texts from Excel into the MS SQL-Server 200 and this texts are making no
problems. This texts will be shown correctly on the browser. Only if I use a
ColdFusion-Script (ColdFusion MX) to write the russian text into the database
there appears only ???? in the table. I declared "utf-8" as characterset. And
by the integration of the database in the adminstrator I clicked "Enable
Unicode for data sources configured for non-Latin characters ".
Who can help me?

[PaulH]

are the columns holding the text "N" datatypes (nchar, nvachar,ntext)? when you
insert text are you using unicode hinting (N')? or are you using cfqueryparam?
you might take a look at [url]http://www.sustainablegis.com/unicode/greekTest.cfm[/url].

[blanked-face]

Many, many thanks!

[PaulH]

if you follow good practicesand use cfqueryparam you should probably read [url]http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=entry&entry=F9553D86-20ED-7DEE-2A913AFD8651643F[/url].