Logo GNT
Actualités Tests & Guides Bons Plans
GTA 6 iPhone 17 Copilot Switch 2 Temu ChatGPT Tesla
OVH Cloud OVH Cloud
Entraide Windows Windows Serveur SQL Serveur SELECT DATABASEPROPERTYEX( db_name(), 'collation ')

SELECT DATABASEPROPERTYEX( db_name(), 'collation ')

2 réponses
Avatar
Meir S., ClearForsest
This line doesn't work on SQL2005:

SELECT DATABASEPROPERTYEX( db_name(), 'collation ')

Please notice the extra space at the end of the string: 'collation ' .
(without the space everything works fine)

It worked on SQL2000.

The extra space is a stupid mistake someone else made a long time ago, and
it never bothered us.
Now it tottaly messes-up our apps, and we need to issue a new patch for
SQL2005.

Has anyone come across any other "backward compatibilty" issues ?
Are the MS guys aware of this ?

Thanks
Meir S.
meir@clearforest.com
Signaler un problème avec ce contenu

2 réponses

Supprimer
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire

Veuillez sélectionner un problème

Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Avatar
עמי לוין
היי מאיר,

העברתי את הטענה שלך הלאה.
אעדכן אם יהיו לי תשובות.

--
HTH

עמי

* אם תשובתי הועילה לך, לחץ "כן" בשורה הכחולה בחלון משמאל ודרג הודעה זו.
------------------------------------------------------------------------------------------------



"Meir S., ClearForsest":

This line doesn't work on SQL2005:

SELECT DATABASEPROPERTYEX( db_name(), 'collation ')

Please notice the extra space at the end of the string: 'collation ' .
(without the space everything works fine)

It worked on SQL2000.

The extra space is a stupid mistake someone else made a long time ago, and
it never bothered us.
Now it tottaly messes-up our apps, and we need to issue a new patch for
SQL2005.

Has anyone come across any other "backward compatibilty" issues ?
Are the MS guys aware of this ?

Thanks
Meir S.






Avatar
Marcelo Colla
are u using 9.0 compability or 8.0 on sql 2005
"Meir S., ClearForsest" escreveu na mensagem
news:
This line doesn't work on SQL2005:

SELECT DATABASEPROPERTYEX( db_name(), 'collation ')

Please notice the extra space at the end of the string: 'collation ' .
(without the space everything works fine)

It worked on SQL2000.

The extra space is a stupid mistake someone else made a long time ago, and
it never bothered us.
Now it tottaly messes-up our apps, and we need to issue a new patch for
SQL2005.

Has anyone come across any other "backward compatibilty" issues ?
Are the MS guys aware of this ?

Thanks
Meir S.