Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...If database server collation is Turkish_CI_AS, @ID and @id variables are not sameIf database server collation is Turkish_CI_AS, @ID and @id variables are not same
Previous
 
Next
New Post
7/30/2007 3:38 PM
 

If database server collation is Turkish_CI_AS, then following error occurs
***
System.Data.SqlClient.SqlException: Must declare the variable '@id'.

...

CREATE PROCEDURE dbo.[AddSearchItemWord]
    @SearchItemID int,
    @SearchWordsID int,
    @Occurrences int

AS

DECLARE @ID int
SELECT @id = SearchItemWordID
...


***

In all type of Turkish collations 'i' is not lowercase of 'I', or vice versa 'I' is not uppercase of 'i'
even in case insensitive mode. This behavior causes problems in queries as @ID is not the same definition as @id, these are two different variables.

btw , I want to explain another key point for Turkish collations and/or Regional Settings
when you are using regex without the option RegexOptions.CultureInvariant "<DIV>" and "<div>" are different.
to match such words containing i with case insensitive behaviour you must use RegexOptions.CultureInvariant option.
Could you please keep these in mind. Maybe somewhere you want to match such a keyword etc.

And could you please update your script files to fix these. i.e script file "04.00.01.SqlDataProvider" in line 40 and 47
replace "@ID" --> "@id"

 
New Post
8/7/2007 4:57 AM
 

I fixed 8 script files for 4.5.5 to support Turkish Collations, actually I just changed cases of some [i]'s.
Here you can find the updated script files compressed in rar format http://www.sbscon.com/files/SqlDataProviderScriptFix.rar

 
New Post
9/19/2007 11:32 AM
 

Hello Serkan, did you log this issue to Support Tracker at support.dotnetnuke.com?


Or-Rouge Team Or-Rouge
Personally recommend Hostgator for hosting single or multiple DotNetNuke Websites.
DotNetNuke Tips and Tutorials
Install DotNetNuke to Godaddy root
DotNetNuke Türkçe Hakkinda Hersey
 
New Post
9/22/2007 4:46 PM
 

no I did not , I will look at it,

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...If database server collation is Turkish_CI_AS, @ID and @id variables are not sameIf database server collation is Turkish_CI_AS, @ID and @id variables are not same


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out