MS SQL Problem With Cyrillic Charchters
Sep 30, 2007
I have a field (type ntext, collation cyrillic). When I enter some text in cyrillic directly over SQL enterprise manager, everything is ok, it displays fine on the web page.
But when I try to enter some text from a web form and execute the query, I get "????????" in the DB.
When looking at the query, everything looks fine.
I tried executing the same query in Query Analyzer, and then I also get "????????".
So only direct text entering works, query doesn't.
What could be the problem?
Thank you.
View 11 Replies
Oct 11, 2005
I have a table content in my database. This table has 5 fields(id, lang1, lang2 ...) type text. The problem is that one of the language fields has to contain some text in Cyrillic but after insert it always converts the text into "???? ??????????? ????????". Can anyone help?
View 1 Replies
View Related
Mar 13, 2008
Hello and greetings from Bulgaria!
The server of zendurl.com crashed and my forum gone away. With some help from the administrator, I got the latest database of it. But the forum is bulgarian, so there was mostly cyrillic. The problem is that the cyrillic can't be read in the latest database. Maybe the admin didn't save it properly. I tried to decode these symbols, but unfortunately with no success. I suppose that the encode must be UTF8 or something like this, I think that it can be done and I hope it works!
Here's the database: http://disasterpriser.data.bg/zendurl_zendurl0sk8ordie.zip
I hope that someone can recover the lost information.
~ Regards, Marto The Creator
View 9 Replies
View Related
Oct 25, 2007
Ok i've tried everything setting table collation to cyrillic setting the whole table language settings to Russian nothing works-i can only save ?????? instead of Russian symvols.(yes datatype is ntext not just text) I can directly input Russian letters from EMS SQL manager, and it will be ok, and i can even read it on my pages. But even if i try to execute SQL command through EMS manager (as opposite to just typing in the data) it will give me ????? again. If I save my ASP.net page in unicode it will give me ?? with some weird ` types symbols-but 70% of symbols would still be ????. I have already spend 45 hours googling and browsing forums but i still cannot solve it! I am so frustrated!
MS SQL Server 2005 Framework 2 ASP.net code looks like Win XP sp2
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.Odbc;
using System.Data.SqlClient;
public partial class registration : System.Web.UI.Page
{
private const string ConnStr = "server=(local);database=main;Trusted_Connection=yes";
private const string ConnStr = "server=(local);database=main;Trusted_Connection=yes";
private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection myConnection = new SqlConnection("server=(local);database=main;Trusted_Connection=yes;");
///ыуаыпвараеоеаореавп is russian random letters
SqlCommand myCommand = new SqlCommand("UPDATE quest SET Name='ыуаыпвараеоеаореавп' WHERE id=1", myConnection);
myConnection.Open();
SqlDataReader dr = myCommand.ExecuteReader();
myConnection.Close();
if i manually stop the script here and look at my dr variable i will see exactly sql command that i wrote (with no ????) but after execution in my database it is still ??????????????????????????????
Best Regards
View 6 Replies
View Related
Apr 21, 2008
Hi,
I am using Microsoft SQL Server 2000. I am inserting cyrillic characters in my table by using query analyzer. See sample below:
Column "LangText" is nvarchar data type.
INSERT INTO Sentences (LangText) VALUES ('Поиск')
Problem occurs when I retrieve via query analyzer by using select statement I got "?????" question marks.
View 6 Replies
View Related
Mar 13, 2015
I am struggling with SQL Server 2008 database in cyrillic language I try to Load data with ETL. But, both of the datetime columns' value are shown as 4015-01-01 as of 2015-01-01.How can i load data in Regular datetime format without parsing the column?
View 2 Replies
View Related
