Re: inserting Turkish chars into sql server

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Sergei Shelukhin (raven_at_at_home.domonet.ru)
Date: 03/14/05 

Date: Mon, 14 Mar 2005 03:49:45 +0300

Sergei Shelukhin wrote:

Nevermind. Only needed to add N to the query, like (N'"+....
> Hi.
>
> Here's the problem.
> I have ASP.NET web app and SQL Server 2k database.
> In the app, there's this button handler.
>
> string sql = "INSERT INTO Word (Word,WTranslation,Comment)
> VALUES
> ('"+txWord.Text.Trim()+"','"+txTranslation.Text.Trim()+"','"+txComment.Text.Trim()+"')";
>
> SqlCommand cmd = new SqlCommand(sql,cn);
> cn.Open();
> cmd.ExecuteNonQuery();
> cn.Close();
> txComment.Text = cmd.CommandText;
>
> Last line is for testing purposes.
> txWord field contains Turkish characters (C with cedilla, g with breve
> etc).
> When I submit the form, I get the right output in the comment field,
> e.g. all the letters are with cedillas, breves etc. I don't know if they
> (symbols) will work with ngs, but here's the query example:
>
> INSERT INTO Word (Word,WTranslation,Comment) VALUES ('çĞ','hhh','')
>
> Problem is that in SQL Servr database, symbols lose all their fancy
> stuff and come out as standart c-s, g-s etc.
>
> Default collation for the db is cyrillic, Word column collation is set
> to Turkish but it doesn't help.
> The same results are produced when I run the query from the query analyzer.
> How do I fix this?

Quantcast