Home
Get Started
Learn
Downloads
AJAX
MVC
Community
Wiki
Forums
Sign in
|
Join
Home
›
ASP.NET Forums
›
Search
Search
You searched for the word(s): userid:526220
More Search Options
RSS Available
Matching Posts
Re: Central European specific characters in SQLExpress
[quote user="ksridharbabuus"] insert into Test_DiffChars2( Col1) values( N 'š, ž, Š, Ž č, ć, đ, Č, Ć, Đ') [/quote] This works! Thank you!!! I wasn't aware of this "N"-syntax at all, thanks for letting me know!
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
imbrod
on 11/3/2008
Re: Central European specific characters in SQLExpress
[quote user="TATWORTH"] First of all as you are using SQL 2005 Express, I suggest that you NVARCHAR(MAX) instead of NTEXT. [/quote] I wasn't aware of that option, I thought max is 255. I'll try that, thanks. [quote user="TATWORTH"] I am surprised that the use of NTEXT did not fix the problem. Please try displaying nav(rs("tekst").ToString) and see of the special characters are there. [/quote] It didn't fix the problem. Displaying shows text without special
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
imbrod
on 11/3/2008
Re: Central European specific characters in SQLExpress
Thanks for the reply, Ksridharbabuus! Unfortunatelly, it didn't help. So when creating table in SQLExpress, I tried these 4 solutions, it all failed: cm2 = New System.Data.SqlClient.SqlCommand("CREATE TABLE trivia (ID SMALLINT IDENTITY(1,1) PRIMARY KEY NOT NULL, tekst TEXT )", cn2) cm2 = New System.Data.SqlClient.SqlCommand("CREATE TABLE trivia (ID SMALLINT IDENTITY(1,1) PRIMARY KEY NOT NULL, tekst NTEXT )", cn2) cm2 = New System.Data.SqlClient.SqlCommand("CREATE TABLE
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
imbrod
on 11/2/2008
Re: Central European specific characters in SQLExpress
I found out that I should change the Collation in SQL Express. How do I do that? By the way, I just realized: this forum's data is probably stored in MSSQL. I can see clearly those characters that I entered in my previous post, therefore I guess this database is configured the way I need, to receive those characters properly. Admin, could you help me out how to achieve that?
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
imbrod
on 11/1/2008
Central European specific characters in SQLExpress
Hi! This is region specific issue, it's about Central European. You see, there are some specific characters in Central Europe (I'll write them here, don't know how you'll see them though: čćšđž ) I have the data in MS Access database. Now, I try to copy the data into SQL Express 2005 database, using the script ("select * from..." MS Access table and "insert into..." MS SQL table) The data is copied correctly except for some of those special characters (plus their
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
imbrod
on 10/31/2008
Re: error: 26 - Error Locating Server/Instance Specified
I changed remote connection to true in sql server surface and it works. I just remembered the reason why it stopped working: I made a 'clean boot' on both computers, therefore SQL was stopped at boot!
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
imbrod
on 10/31/2008
error: 26 - Error Locating Server/Instance Specified
Hi, I wasn't working with MS SQL for a while. When I installed VWD 2008 Express & SQL Express, I tested some simple apps with database and it was working fine before. Months later, I tried clicking on the database in VWD and got this error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
imbrod
on 10/31/2008
Filed under: ms sql server sqlexpress connection failed
Re: BulletedList shows encoded HTML?
... or maybe I'll try with HTML control <ul runat="server"> instead of BulletedList control...
Posted to
Data Presentation Controls
(Forum)
by
imbrod
on 10/8/2008
Re: BulletedList shows encoded HTML?
Geeee... Regex, rendering... all that for the simple formatting that should be default? No, thanks, I'll stick to classic ASP
Posted to
Data Presentation Controls
(Forum)
by
imbrod
on 10/8/2008
Re: BulletedList shows encoded HTML?
You misunderstood. I don't have just <b>boldedtext</b>, I have a complete concatenated HTML string: ...New ListItem("<b>" & rs("author_name").ToString & " " & rs("author_surname") & "</b> - " & rs("author_date").ToString & "<br />" & rs("author_description").ToString) Anyway, thanks for the link, I'll check it out.
Posted to
Data Presentation Controls
(Forum)
by
imbrod
on 10/8/2008
Page 1 of 22 (220 items) 1
2
3
4
5
Next >
...
Last »
ASP.NET:
PDC09: ASP.NET MVC 2: Ninjas Still on Fire Black Belt Tips
ASP.NET:
Hanselminutes Podcast 188: ASP.NET MVC 2 Beta with Phil Haack
ASP.NET:
Hanselminutes Podcast 186: .NET Debugging 101 with Tess Ferrandez
TechNet Edge:
WinRE and free stuff with Sean Kearney
WindowsClient:
XslCompiledTransform and large template elements
WindowsClient:
The Future of Client App Dev : WPF and Silverlight Convergence
Channel 9:
PDC09 GeekFest Party
Channel 10:
How to Use "Play to" and "Remote Media Streaming" in Windows 7
Channel 9:
The Visual Studio Documentary: Jeff Hadfield Full Length Interview
TechNet Edge:
Managing Your Entire World - Tech Focus November 2009 Part 3
Channel 9:
The Access Show: Managing Access Databases with SharePoint
Channel 10:
Show Us Your Tech - Mark Pendergrast Edition
TechNet Edge:
Mark Russinovich interview at TechEd EMEA 09
TechNet Edge:
IT Manager Podcast #31: Talking About Virtualization
TechNet Edge:
System Center Operations Manager 2007 R2 – Service Level Dashboard part 1: Introduction
WindowsClient:
MSXML XHTML DTDs - making the web better
TechNet Edge:
How it works: Active Directory Rights Management Services
Channel 9:
Inside Windows 7: Recovering Windows from System Degradation and Boot Failures
Channel 10:
Ebay Launches IE8 Webslice for Holiday Shopping
Channel 10:
New Windows Smartphone Includes Built-in PowerPoint Projector
Microsoft Communities
ASP.NET
Channel 8
Channel 9
Channel 10
IIS.NET
Silverlight
TechNet Edge
WindowsClient
Mix Online