January 19, 2012 at 3:01 pm
Hi everybody ,
I have an issue about SQL Server Collations.
Our owned programmed database use Case-Insensitive/Accent Insensitive data ordered like ASCII characters table.
Here is this sort order :
32 (space)
! 33
" 34
# 35
$ 36
%37
& 38
’ 39
( 40
) 41
*42
+43
, 44
- 45
. 46
/ 47
0 48
...(Others numbers from 49 to 57)
: 58
; 59
<60
=61
>62
?63
@64
A 65
...(others UPPER LETTERS From 66 to 90)
[ 91
\ 92
...
a 97;
...(others LOWER LETTERS FROM 98 TO 122)
...(others symbols)
à 224;
...OTHERS LETTERS WITH ACCENTS
...(others symbols)
You can look at http://www.asciitable.com/
My issue: I have to find a way to do the same in SQL Server (a collation that respects the begin of ASCII table sort with CASE INSENSITIVE/ACCENT INSENSITIVE).
Then, the result will be like:
! , ", #, $, %, &, ’, ..., 0,1,2, 3, .... A, a, à, O, o, ô, E, e, é, è, ê, .....
I have made many searches and I found that binaries collations respect ASCII table sort order but they do not support CASE INSENSITIVE/ACCENT INSENSITIVE options. However, non binaries collations support CASE INSENSITIVE/ACCENT INSENSITIVE but do not respect ASCII table sort order
I tried without success :
DataBase Collation = CollationXXX_BIN with SELECT column with COLLATE CollationXXX_CI_AI
DataBase Collation = CollationXXX_CI_AI with SELECT column with COLLATE CollationXXX_BIN
Is there a way that could solve my problem ? A way to create my own collation in SQL Server ?
Thank you very much 🙂
PS: I don't speak english very well but i Hope you'll understand 😎
January 19, 2012 at 3:05 pm
Duplicate post
Please post answers here
http://www.sqlservercentral.com/Forums/Topic1239099-391-1.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply