dear all,

I want to send greek data to SQL Server 2000 database from a
ASP.net web form. 
However, when I type greek in the
field and submit the form, the data does not update properly. When the form
posts, I can see the greek text being submitted in the next page, but not
properly encoded to the database. I see ?????? in the database table and
also when I retrieve the data later.  
It used to work fine when I used OLEDB connection with ASP. 
But does not seem to get it work using Sqlclient in ASP.net. 
However, I can retrieve the greek text if I manually enter it in
the SQL server tables.

Some info on the environment:
1. ASP.NET in Wndows 2000 Server
2. Microsoft SQL 2000 Server running in Windows 2000 Server


Could somebody please help me with this. Thanks in advance.

Vicky

Hello Vicky.

It's not a matter of the SQL Server the encoding. Try to select the greek
language support from the Control Panel.
I use the same tachnologies but i can write greek characters to my database.
"Den kovw kai to xeri mou" but i encarage you to follow my advice.
Lefterhs.
----- Original Message -----
From: "vicky papaioannou" <vikyp@o...>
To: "Website Programming with ASP.NET"
<aspdotnet_website_programming@p...>
Sent: Friday, April 26, 2002 9:37 AM
Subject: [aspdotnet_website_programming] problem sending greek data to
database


> dear all,
>
> I want to send greek data to SQL Server 2000 database from a
> ASP.net web form.
> However, when I type greek in the
> field and submit the form, the data does not update properly. When the
form
> posts, I can see the greek text being submitted in the next page, but not
> properly encoded to the database. I see ?????? in the database table and
> also when I retrieve the data later.
> It used to work fine when I used OLEDB connection with ASP.
> But does not seem to get it work using Sqlclient in ASP.net.
> However, I can retrieve the greek text if I manually enter it in
> the SQL server tables.
>
> Some info on the environment:
> 1. ASP.NET in Wndows 2000 Server
> 2. Microsoft SQL 2000 Server running in Windows 2000 Server
>
>
> Could somebody please help me with this. Thanks in advance.
>
> Vicky
>

Dear Lambro

thank you for your answer but i have already changes the settings in the
control panel!!!
default language on the server is greek
how do you do it? i could really use your help
Let me explain a bit more.....
I have an ".aspx" form with a text field. I am using a stored procedure to
send the data to the SQL server 2000 database
And the data is then submitted as ????? .
I have changed the encoding in the page... i know this is not what couses
the problem
also i have my database field to nvarchar.... to allow storage of
unicode....
but still nothing
i also have collation setting to Winow-Greek ....

Any chance to help me out?
thanks again
Vicky

----- Original Message -----
From: "Lampros Eleftherios" <lampros@c...>
To: "Website Programming with ASP.NET"
<aspdotnet_website_programming@p...>
Sent: Friday, April 26, 2002 7:59 AM
Subject: [aspdotnet_website_programming] Re: problem sending greek data to
database


> Hello Vicky.
>
> It's not a matter of the SQL Server the encoding. Try to select the greek
> language support from the Control Panel.
> I use the same tachnologies but i can write greek characters to my
database.
> "Den kovw kai to xeri mou" but i encarage you to follow my advice.
> Lefterhs.
> ----- Original Message -----
> From: "vicky papaioannou" <vikyp@o...>
> To: "Website Programming with ASP.NET"
> <aspdotnet_website_programming@p...>
> Sent: Friday, April 26, 2002 9:37 AM
> Subject: [aspdotnet_website_programming] problem sending greek data to
> database
>
>
> > dear all,
> >
> > I want to send greek data to SQL Server 2000 database from a
> > ASP.net web form.
> > However, when I type greek in the
> > field and submit the form, the data does not update properly. When the
> form
> > posts, I can see the greek text being submitted in the next page, but
not
> > properly encoded to the database. I see ?????? in the database table and
> > also when I retrieve the data later.
> > It used to work fine when I used OLEDB connection with ASP.
> > But does not seem to get it work using Sqlclient in ASP.net.
> > However, I can retrieve the greek text if I manually enter it in
> > the SQL server tables.
> >
> > Some info on the environment:
> > 1. ASP.NET in Wndows 2000 Server
> > 2. Microsoft SQL 2000 Server running in Windows 2000 Server
> >
> >
> > Could somebody please help me with this. Thanks in advance.
> >
> > Vicky
> >
>
>
>
>