Hi,



This is the scenario. 

We have developed a site in Ukrainian. The Site has some Static html pages 

and ASP pages.The dynamic content is retrieved from SQL server.



Initially when we tried to display the Ukrainian characters through static 

html  pages we had some problems. We solved that by specifying the 

character set in the meta tags as Windows-1251.This character set supports 

the ukrainian characters.



Now we needed to store the ukrainian data into the Database with SQL Server's

default language as English. We tried to insert the data maually into the 

database but the data got inserted into a series of question marks

"??????". Then we posted the data through a form into the Database it got

inserted as some equivalent characters.





In order to overcome this we changed the Language setting of the SQL Server 

as ukrainian by reinstalling SQL server.But there was no change from the 

above situation.



Finally we reinstalled the Operating system with Ukrainian as the default

regional setting and then installed the SQL server with default language

setting as Ukrainian.We also installed the IIS in the same machine where the

OS is set by default as Ukrainian.



Now the Ukrainian characters are supported by the SQL Server.Our site also

has a search funtionality.So we need to have index server along with IIS and

Full Text Search option with SQL server.



With all this we got the site working.





But unfortunately the hosting company is unable to provide an entirely 

Ukrainian Language based environment. They need to host the website in a 

server with English as the default setting for the OS and SQL server due to 

some other contraints.



With English as the default language for the OS and SQL ,only some 

equivalent charaters would get entered into the Database other than the 

original ukrainian characters.The site might not support the Search 

functionality as the index server cannot search for these equivalent 

characters and display the matches based on them.



What could be the solution for the above problem? Please suggest if 

something could be done.



Thanks in advance,





-Shrikar