Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-27 : 10:43:09
|
| slatha writes "I have designed an vb application with a text box and a button.I set the textbox's font to 'Kamban', a Indian language font.When I type 'hello' in the box, its displayed in 'Kamban' font and not in englis as 'hello'.But when saving, its stored as 'hello' in english.I want to store it exactly as it appears in the textbox.As you said, I place N before the value.that is , i coin the insert sql string asstrSQL = "insert into table1(name) values(N'" & text1.text & "')"connectionVariable.execute(strSQL).How should I convert the text into unicode characters.I execute the command insert into tableunicode([Name], [Text])values(N'Èùï éò', N'Åó÷å')in the SQL server's query analyser window.This value for [Name] column is stored as Èùï éòno unicode characters are displayed.So I think I have to configure SQL Server for that.Should I?I made the fields of 'nvarchar' datatype.And I have checked the 'indic' checkbox in Control Panel ->Regional Options->General.Thankx in advanceLatha" |
|
|
|
|
|
Storing Unicode characters in SQL server