more infos about collation SQL_AltDiction_CP1253... ? 
Author Message
 more infos about collation SQL_AltDiction_CP1253... ?

Hi,

I was playing with collation in order to see if I can find a trick to
return strings without diacritics (accents) easily... and was pleased to
find that this :

select 'fran?ois??$' collate SQL_AltDiction_CP1253_CS_AS

works perfectly.

If I do a
SELECT COLLATIONPROPERTY('SQL_AltDiction_CP1253_CS_AS', 'LCID')
SELECT COLLATIONPROPERTY('SQL_AltDiction_CP1253_CS_AS', 'CodePage')

The LCID is 1033 = English US, when the CodePage is 1253 = Greek

Does someone know what means 'AltDiction' ? And if there's somewhere more
info about the SQL server collations, (than the description returned by
::fn_helpcollations() ) ?

tia,
rudi



Mon, 15 Aug 2005 22:44:29 GMT
 more infos about collation SQL_AltDiction_CP1253... ?

The "AltDiction" portion of the collation simply deals with the way the
collation will sort certain characters, which is not relevant for the
purposes you are working toward.  The relevant piece of that collation is
CP1253, which is the Greek code page.  This code page happens not to have
any of the extended characters (characters with diacritic marks) that are
used in the example you provided.  However, it does include all the
characters in http://www.microsoft.com/globaldev/reference/sbcs/1253.htm.  

This means that the query:

    select N'?????' collate SQL_AltDiction_CP1253_CS_AS

Will return other characters with diacritics, although you may not care
about these (The characters I selected probably won't survive the posting.  
If you see ?'s above, replace the series of ?'s with the output of the
query: "SELECT NCHAR (0x386) + NCHAR (0x03cc) + NCHAR (0x03cb) + NCHAR
(0x03ac) + NCHAR (0x03af)").  

There is no "simple ASCII" collation.   The non-Unicode code pages
supported by SQL Server are listed in the Books Online article
"Collations".  The characters supported by each of those code pages can be
viewed at http://www.microsoft.com/globaldev/reference/cphome.mspx.  By
forcing a conversion to a different code page you are forcing a best match
conversion, which will typically result in some approximate conversions for
characters that don't exist in the destination code page, as you have seen.

Bart
------------
Please reply to the newsgroup only - thanks.

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| Subject: more infos about collation SQL_AltDiction_CP1253... ?

| Organization: MSC

| User-Agent: Xnews/5.04.25
| Newsgroups: microsoft.public.sqlserver.programming
| Date: Thu, 27 Feb 2003 06:44:29 -0800
| NNTP-Posting-Host: 212.147.105.50
| Lines: 1        
| Path:
cpmsftngxa08.phx.gbl!cpmsftngxa06!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: cpmsftngxa08.phx.gbl microsoft.public.sqlserver.programming:335958
| X-Tomcat-NG: microsoft.public.sqlserver.programming
|
| Hi,
|
| I was playing with collation in order to see if I can find a trick to
| return strings without diacritics (accents) easily... and was pleased to
| find that this :
|
| select 'fran?ois??$' collate SQL_AltDiction_CP1253_CS_AS
|
| works perfectly.
|
| If I do a
| SELECT COLLATIONPROPERTY('SQL_AltDiction_CP1253_CS_AS', 'LCID')
| SELECT COLLATIONPROPERTY('SQL_AltDiction_CP1253_CS_AS', 'CodePage')
|
| The LCID is 1033 = English US, when the CodePage is 1253 = Greek
|
| Does someone know what means 'AltDiction' ? And if there's somewhere more
| info about the SQL server collations, (than the description returned by
| ::fn_helpcollations() ) ?
|
| tia,
| rudi
|



Tue, 16 Aug 2005 00:31:09 GMT
 more infos about collation SQL_AltDiction_CP1253... ?
Thanks for the reply.

Well, that looks good so far. If I understand well, the "approximate
conversions" are doing the trick here, and well enough to make the thing I
need - admittedly not particularly safe, but acceptable for my needs.

rudi



Quote:

> There is no "simple ASCII" collation.   The non-Unicode code pages
> supported by SQL Server are listed in the Books Online article
> "Collations".  The characters supported by each of those code pages
> can be viewed at
> http://www.microsoft.com/globaldev/reference/cphome.mspx.  By forcing
> a conversion to a different code page you are forcing a best match
> conversion, which will typically result in some approximate
> conversions for characters that don't exist in the destination code
> page, as you have seen.



Tue, 16 Aug 2005 15:26:50 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. data of 950 collation within database of 936 collation

2. server collation vs database collation issue

3. Windows Collation VS SQL Collation

4. Infos about the exam : 70-019 !

5. Database Infos

6. Vacuum analyze infos

7. VB 5.0 comments, infos needed

8. Extract infos from database

9. Printing infos

10. Database/Table infos

11. need infos.

12. Infos


 
Powered by phpBB® Forum Software