http://sqlserver.ro/forums/14/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/8250.aspxThu, 06 May 2010 17:24:17 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8250Diana0http://sqlserver.ro/forums/thread/8250.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=8250You're welcome :) <br />Vezi si <br />http://support.microsoft.com/kb/239530 <br />Nu e nevoie sa schimbi collation pentru intreaga baza de date. Collation se poate defini si la nivelul unei coloane dintr-un tabel.http://sqlserver.ro/forums/thread/8249.aspxThu, 06 May 2010 15:59:09 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8249Sergiu0http://sqlserver.ro/forums/thread/8249.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=8249A mers cu:<br>select * from vpatients where firstname like N'Ş%'<br>Mersi mult!!!<br>http://sqlserver.ro/forums/thread/8247.aspxThu, 06 May 2010 11:04:14 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8247Diana0http://sqlserver.ro/forums/thread/8247.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=8247Incearca <br />select * from vpatients where firstname like N'Ş%' COLLATE [romanian collation]http://sqlserver.ro/forums/thread/8246.aspxThu, 06 May 2010 10:59:30 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8246Sergiu0http://sqlserver.ro/forums/thread/8246.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=8246Baza de date are Collation - SQL_Romanian_CP1250_CI_AShttp://sqlserver.ro/forums/thread/8245.aspxThu, 06 May 2010 10:52:56 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8245katalyn0http://sqlserver.ro/forums/thread/8245.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=8245Dar collation-ul bazei de date ?http://sqlserver.ro/forums/thread/8244.aspxThu, 06 May 2010 10:47:22 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8244Sergiu0http://sqlserver.ro/forums/thread/8244.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=8244interogarea e banala: select * from vpatients where firstname like "Ş%"<br>nu folosesc collate in interogare.&nbsp; tipul de date a coloanei este nvarchar. aceleasi setari inseamna acelasi collation la server si la baza de date. Clientul se conecteaza la serverul instalat la el. Ma intereseaza la ce setari ar mai trebui sa atrag atentia, odata ce la mine merge, iar la client - nu. Poate sa fie ceva legat de setarile sistemului de operare?<br>http://sqlserver.ro/forums/thread/8243.aspxThu, 06 May 2010 10:18:15 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8243Diana0http://sqlserver.ro/forums/thread/8243.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=8243Te rog trimite query-ul cu probleme. <br />Folosesti COLLATE? Prefixezi search string-ul cu N? Ce tip de date are coloana in care cauti? etc, etc...:) <br />Ce inseamna "aceleasi setari"? Clientul se conecteaza la serverul tau? <br />Vezi si BOL ---> Collation precedence. <br />http://sqlserver.ro/forums/thread/8242.aspxThu, 06 May 2010 09:40:02 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8242Sergiu0http://sqlserver.ro/forums/thread/8242.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=8242Salut baieti! Am o problema pe care nu o pot rezolva :( si... trec direct la subiect:<br>Am un SQL Server 2005 cu Collation - SQL_Latin1_General_CP1_CI_AS<br>Baza de date are Collation - SQL_Romanian_CP1250_CI_AS<br>Vreau sa fac un select in care sa-mi afiseza persoanele, numele carora incep cu litera "Ş".<br>Paradoxul este ca pe calculatorul meu totul e OK, iar pe calculatorul clientului (care are "aceleasi" setari) interogarea intoarce persoanele, numele carora incepe cu "S". <br>Sistemul de operare pe care ruleaza serverul este MS Windows 2003 Server.<br>Ceva imi scapa... dar ce?<br><br><br><br>