sql server mseq: I USE SQL SEVER 2000
I HAVE A TABLE IN A DB CALLED "Trend_Velocità"
I HAVE A QUERY ON A ADO OBECT "SELECT * FROM Trend_Velocità" in a Vb program
IF THE DEFAULT VALUE OF LANGUAGE IS ENGLISH NO PROBLEM
If I set the default value to russian the vb instrucion give me the error :
invalid object name 'Trend_Velocita'
what's wrong? Why à in a in the message ?

I don't know where you are setting the default language, but I do
know that the Russian and other Cyrillic code pages for character
data do not support accented characters. If it is possible to use
a Unicode data type for the query string, the accented characters
will not be replaced. Here is a demonstration of the SQL Server
side of your issue.

create table T (
s_Russian varchar(20) collate Cyrillic_General_CS_AS,
s_English varchar(20) collate Latin1_General_CS_AS,
s_Unicode nvarchar(20)
)
insert into T values('Trend_Velocità','Trend_Velocità',N'Trend_Velocità')
go

select * from T
go

drop table T

-- Steve Kass
-- Drew University

[quoted text, click to view]