Database Discussion - problem with non-english characters in MS SQL 2005

Print Page | Close Window

problem with non-english characters in MS SQL 2005

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=27297
Printed Date: 28 March 2026 at 4:56pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: problem with non-english characters in MS SQL 2005

Posted By: tjodalv
Subject: problem with non-english characters in MS SQL 2005
Date Posted: 27 April 2009 at 6:36pm

Hello

I have problem inserting non-english characters into MS SQL 2005 database. My page with form that collect data is UTF-8. When I try to insert characters like čć they are stored in my MS SQL database like cc, but characters like šž are ok.

My database fields are nvarchar type. I really cant find solution to this.

What is the problem, and how to solve it ?

Thank you in advance.

Replies:

Posted By: 123Simples
Date Posted: 27 April 2009 at 6:51pm

http://forums.webwiz.net/search-function-dont-work_topic27220_post139312.html?KW=encoding#139312" rel="nofollow - Check this topic and you may have to alter your includes/setup_options_inc.asp

-------------
http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design

Posted By: tjodalv
Date Posted: 27 April 2009 at 6:53pm

Well i am not having problem with my copy of WWF, i am building application of my own.

I could change collation to Croatian, but I am building an international application where it could be used croatian, french, italian or russian character so I need some solution to my database that will accept all the characters.