Web Wiz
Home
Home
Hosting Services
Hosting Services
Knowledgebase
Knowledgebase
Community
Community
Customer Login
Customer Login

Web Wiz Forums Homepage

  New Posts New Posts RSS Feed - problem with non-english characters in MS SQL 2005
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

problem with non-english characters in MS SQL 2005

 Post Reply Post Reply
Author
tjodalv View Drop Down
Newbie
Newbie


Joined: 03 May 2006
Location: Croatia
Status: Offline
Posts: 21
Points: 25
Post Options Post Options   Quote tjodalv Quote  Post ReplyReply Direct Link To This Post Topic: problem with non-english characters in MS SQL 2005
    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.
Back to Top
MrTWS View Drop Down
Moderator Group
Moderator Group
Avatar

Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Posts: 960
Points: 933
Post Options Post Options   Quote MrTWS Quote  Post ReplyReply Direct Link To This Post Posted: 27 April 2009 at 6:51pm
Check this topic and you may have to alter your includes/setup_options_inc.asp
Back to Top
tjodalv View Drop Down
Newbie
Newbie


Joined: 03 May 2006
Location: Croatia
Status: Offline
Posts: 21
Points: 25
Post Options Post Options   Quote tjodalv Quote  Post ReplyReply Direct Link To This Post 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.

Edited by tjodalv - 27 April 2009 at 6:57pm
Signature removed by admin, as promotion of hosting companies is not permitted
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down


© Copyright 2001-2010 Web Wiz®. All rights reserved.
All prices are shown excluding VAT, which is charged where applicable. $, € prices shown as a guideline only.