I have asp.net site which needs to sae cyrillic text.

I have changed the sql server table column to accept the text and also 
placed a N in fornt of the sql code to insert it.   eg.  Insert (text) ( N' 
some cyrillic text')

all works ok from  the dev machine and saves ok in database.   But when I 
deploy to the windows server 2003 sp2   it starts inserting ??????  I have 
checked that the codepage windows 1251 and 1252  are installed on both 
machines,

So any ideas how to fix this?

On Aug 7, 9:56 am, martin  wrote:

> I have asp.net site which needs to sae cyrillic text.
>
> I have changed the sql server table column to accept the text and also
> placed a N in fornt of the sql code to insert it.   eg.  Insert (text) ( N'
> some cyrillic text')
>
> all works ok from  the dev machine and saves ok in database.   But when I
> deploy to the windows server 2003 sp2   it starts inserting ??????  I have
> checked that the codepage windows 1251 and 1252  are installed on both
> machines,
>
> So any ideas how to fix this?


Hi Martin

check <globalization> tag in web.config

Hope it helps

Hi Alexey

Yes I tried that I put  windows-1251    but no joy , still saved as ???????

The wierd thing is when I run on my dev machine ( win xp)  it all works ok,  
but when deployed to server it stops.   On the dev machine I have not put any 
globalisation tags in the web config, but it still works !?





"Alexey Smirnov" wrote:


> On Aug 7, 9:56 am, martin  wrote:
> > I have asp.net site which needs to sae cyrillic text.
> >
> > I have changed the sql server table column to accept the text and also
> > placed a N in fornt of the sql code to insert it.   eg.  Insert (text) ( N'
> > some cyrillic text')
> >
> > all works ok from  the dev machine and saves ok in database.   But when I
> > deploy to the windows server 2003 sp2   it starts inserting ??????  I have
> > checked that the codepage windows 1251 and 1252  are installed on both
> > machines,
> >
> > So any ideas how to fix this?
> 
> Hi Martin
> 
> check <globalization> tag in web.config
> 
> Hope it helps
> 
> 

Martin,

I got a similar problem that was solved by changing the field definition 
from nvarchar to ntext.
I could afford the extra-cost of a "ntext" in my project but maybe this is 
not an efficient solution in your situation.

Michel


"martin"  wrote in message 
news:98A60B79-73C4-4113-A8D4-4D20D2FD903B@microsoft.com...

>I have asp.net site which needs to sae cyrillic text.
>
> I have changed the sql server table column to accept the text and also
> placed a N in fornt of the sql code to insert it.   eg.  Insert (text) ( 
> N'
> some cyrillic text')
>
> all works ok from  the dev machine and saves ok in database.   But when I
> deploy to the windows server 2003 sp2   it starts inserting ??????  I have
> checked that the codepage windows 1251 and 1252  are installed on both
> machines,
>
> So any ideas how to fix this?
>
>
>
> 

Maybe you don't have the right font on production server?

On Aug 8, 5:30 am, misko.e...@gmail.com wrote:

> Maybe you don't have the right font on production server?


:-)