tags:

views:

3

answers:

0
Q: 

Problem with Persian_CI_AI collation And 'ك' character

Hi, I installed sql server 2008 enterprise and created a sample database whit Persian_CI_AI Collation. then from a visual studio 2010 windows application i insert the word "اسكندر" whith two type of 'ك'(arabic & Persian) but in the search time result show me just one 'اسكندر' . Please Help me

related questions

MySql alter table Collation
When must we use NVARCHAR/NCHAR instead of VARCHAR/CHAR in SQL Server?
How to sort text in sqlite3 with specified locale?
Change collation on clustered index column in SQL 2005
Japanese/Chinese language data in SQL Server table
Sql Server 2008 - Difference between collation types
Does sqlserver collation mean column names must be correct case? And how to deal with that...
MySQL internationalization with DCM4CHEE
Comparing strings in PHP the same way MySQL does
What is the best collation to use for MySQL (with PHP)
SQL Stored Proc Collation Context
phpmyadmin displays japanese characters as a bunch of question marks even if i set charset and collation to utf8_unicode_ci
JavaScript: Efficiently replace all accented characters in a string?
how to force php to use utf-8 charset
MySQL collations not working as advertised in documentation
The application sorts strings differently than the database
Sql Server Management - Option to avoid scripting the collation?
Differences in prepared vs. direct statements using Oracle ODBC
MySQL - Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'UNION'
Change SQL Server 2005 Server Collation
What is the best way to select string fields based on character ranges?
How do I find out what collations are available in SQL 2000/2005
How do I perform a case-sensitive search and replace in SQL 2000/2005?
How do I determine the collation of a database in SQL 2005?
A script to change all tables and fields to the utf-8-bin collation in MYSQL